Sharing

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

I am trying to save a database while other users are in
the database, an error message of "You do not have
exclusive access to the database at this time. Your
design changes will not be saved".

Does Anyone know how to solve the problem?
 
I assume that you are the developer making form changes etc
and the others are the real users of the system. In which
case, you will have to wait until they all close the
database before you can incorporate your changes.

It may be worth considering splitting your application into
a Front/Back scenario where the tables reside in the Back
and the other objects reside in the Front with LinkedTables
providing the connection between the two. Whilst the Back
sits on a Network Drive, the Front can reside on each users
local drive. As the Front contains nothing that the user
would update, it means that you can make changes to the
'Master' copy (always remebering to take copious backups)
then distribute the amended version to the users when you
wish. This way, you only encounter the exclusive problem
when you need to make changes to the table designs.

Hope This Helps
Gerald Stanley MCSD
 
Back
Top