Exclusive Access: Urgent

[nikhil]

Hello all,

I had a quick question. Everytime i attempt to open my
forms in design view a message stating " you do not have
exclusive access to the database at this time..." appears.
now there is another user on, but she is just importing
queries. i checked under the options menu, and the open
mode is set to shared. do you have any suggestions of what
causes this, and how i can fix this problem.

thank you in advance,

Nikhil

 

[Joan Wild]

New, in 2000 and 2002, you cannot make design changes while another user has
the database open, regardless of what they are doing in it.

The usual method to overcome this is to split the database into
frontend/backend. The backend contains only tables and is put on a server.
The frontend contains all the other objects, and is linked to the backend.
There is a database splitter wizard you can use to split the database.

You would give each user a copy of the frontend on their computer. The copy
on your computer you can use to make design changes to forms/reports. When
you have completed your changes, you simply deploy the updated frontend to
the users.

There are methods of automating this update. Tony Toews has one example at
http://www.granite.ab.ca/accsmstr.htm. Look for frontend updater.