Annoying warning message.

D

dericksonfl

Thank you for your previous help.

I have a time tracking database that is utilized by about 20 people each
week. Everything works fine but on occasion, users are prompted with the
message:
"You do not have exclusive rights to the database at this time. If you
proceed to make changes, you may not be able to save them later." Users have
been instructed to "ok" past it and all seems to be well when I check the
underlying table.

Is there a way to turn off this message and if so, is there any risk with it
not popping up? We have lived with it for a year and have never had a data
issue.
 
D

Douglas J. Steele

Sounds as though all your users are opening the same database.

You should split it into a front-end (containing the queries, forms,
reports, macros and modules) and a back-end (containing the tables and
relationships).

Only the back-end should be on the server: each user should have his/her own
copy of the front-end, preferably on their hard drive.

If you're concerned that each user has the correct version if changes are
made to the application, check out the free Auto FE Update Tony Toews has at
http://www.granite.ab.ca/access/autofe.htm
 
Top