Modify db while others are on it.

[Guest]

I've created a secured ACCESS db and give permissions, etc. I specifically gave myself admin permssions to run exclusively. I did not provide Users with this permission. When others are using the database I am unable to make modifications. Is it possible?

 

[Rick Brandt]

I've created a secured ACCESS db and give permissions, etc. I

specifically gave myself admin permssions to run exclusively. I did not
provide Users with this permission. When others are using the database I
am unable to make modifications. Is it possible?

Access 97 was the last version that allowed you to modify *objects* while
others were in the file. After that you can modify data only unless you
have the file opened exclusively. There is no work-around. Even in
versions that allowed this is was never a good idea.

You should be using a split application where one shared file contains only
the tables and each user has their own local copy of a file with all other
objects. This allows you as the developer to work on changes in another
separate copy of the "front end" file and then you distribute it to the
users when finished.

 

[Guest]

-----Original Message-----
I've created a secured ACCESS db and give permissions,

etc. I specifically gave myself admin permssions to run
exclusively. I did not provide Users with this
permission. When others are using the database I am
unable to make modifications. Is it possible?