R
Razor
Hi,
I have an MDB that will be accessed by several users
worldwide (6 global regions) off of a shared drive
(fileserver).
I want users in a region to have write-rights to only
their region-specific records and be able to read all the
records.
How should I implement this?
I am thinking of splitting, making 6 front-ends and
keeping them all on the shared drive each in its own
folder and enforcing that users only use the front-end
assigned to their region by using folder-level
permissioning though login IDs.
Also, it is my understanding that the locking methodology
is enforced by the way Access is configured for the first
one in the file.
Despite the above, can I enforce pessimistic locking
through code that must run when someone launches their
front-end?
I know about variuos third-party tools such as Auto FE
Updater, but I need to do this in the simplest possible
way.
Thanks!
Razor
I have an MDB that will be accessed by several users
worldwide (6 global regions) off of a shared drive
(fileserver).
I want users in a region to have write-rights to only
their region-specific records and be able to read all the
records.
How should I implement this?
I am thinking of splitting, making 6 front-ends and
keeping them all on the shared drive each in its own
folder and enforcing that users only use the front-end
assigned to their region by using folder-level
permissioning though login IDs.
Also, it is my understanding that the locking methodology
is enforced by the way Access is configured for the first
one in the file.
Despite the above, can I enforce pessimistic locking
through code that must run when someone launches their
front-end?
I know about variuos third-party tools such as Auto FE
Updater, but I need to do this in the simplest possible
way.
Thanks!
Razor