Annoying warning message.

[Guest]

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.

 

[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

 

[Danny J. Lesandrini]

Is the data in MS Access or SQL Server?
Are people actually editing the same records at the same time?

You could change the locking strategy, but I'm not sure that it's the best
idea. On the other hand, if the data is in SQL Server and users are not
really colliding, then what you need are timestamp fields on every table.