| Title: | MSACCESS |
| Moderator: | BUMP::HONER |
| Created: | Tue Dec 01 1992 |
| Last Modified: | Mon Jun 02 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1661 |
| Total number of notes: | 6339 |
Looking for some help. My group has a consultant creating an Access
database to be used by sales reps (250) worldwide. All of the data will
be exported into a file. This data needs to get to the sales reps manager
(country level) (50) for review. Then the Manager will send the data to
an area manager(3, US, Europe and AP). The data is then reviewed again
and finally sent to headquarters(1).
The determination has not been made as to how the 'files' will be
moved. One possibility is to use Exchange to Mail the files but Europe
and AP are not all on exchange yet. A second option is to have a
server that the data can be sent to, but this requires IS support and
possibly security issues.
Has anyone had to deal with anything like this before? Any suggestions
would be appreciated.
Nancy
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 1644.1 | BUSY::SLAB | Baroque: when you're out of Monet | Tue Mar 25 1997 09:45 | 16 | |
If they're all on VMS, the .MDB file can be copied by anyone as
long as it's an unprotected file in an accessible area.
For example, if you were to copy DATABASE.MDB to your own top-
level directory, you could do a
SET PROT = (S:RWED,O:RWED,G:RE,W:RE) DATABASE.MDB
and the entire world would be able to copy it.
But keep in mind that anyone will be able to modify their own
copy, so if everyone makes changes it could get ugly. You'd
need a central person to keep the original database and take
the responsibility of making all requested changes.
| |||||