Exclusive access error message

[Miquel Korah]

Hi we currently have a database on the network that is shared betwee
users. Everytime one of us tries to edit a form while someone else i
using the database it comes up with the following error message "You d
not have exclusive access to the database...and your changes will no
be saved". This means that we have to wait for the other person t
close the database before we make any changes to it.

I have checked the Tools->Options->Advanced. The shared option i
ticked. By the way the database is password protected. Is there anyon
out there who knows how to fix this problem.

Would appreciate some help on this.

Thanks Miquella

 

[John Spencer (MVP)]

BY Design, you cannot "code" the database when it is in use. The best way to
fix this is to split the database (use the wizard) and give each user a copy of
the front end. Then you can open your copy of the frontend and make changes to
forms, queries, reports, macros, and modules. Once you have done so, tested the
changes, and are satisified with the results - you give your colleagues an
updated front end.

The back end (consisting of the tables) still can only be edited when you have
exclusive access, but once you have set up the table structure that should be a
rare occurence.