Question Frustrating - You do not have exclusive access warning

[kjh]

I am running Access 2010. The datablase is split with front end running on my machine and the back end on the server. I have 4 other users using Access Runtime. My settings are set to "Shared" with "No Locks". The users on runtime can use the database with no warnings however if they have the database open and then I open it I get the warning "you do not have exclusive access....." It may have something to do with the fact that today I was making some changes and someone popped it open on me through the runtime. Anyone have any ideas on this. Thanks in advance. Please go easy on the code talk because I don't understand it.

 

[Beetle]

If all users are sharing the same front end then that's the problem. Each user should have their own copy of the front end.

 

[kjh]

I am not sure I understand. I have loaded access 2010 on my machine and have downloaded access runtime on the rest of the machines. We all use shortcuts pointing the database strored on the server. What do you mean by their own copy of the front end? bear with me, I may have things set up wrong.

 

[Beetle]

There should be one copy (not including backups) of the back end file (the tables).

There should be multiple copies (one for each user) of the front end file (queries, forms, reports, code). Each user should have their own copy of the front end stored locally on their PC.

If you only have one copy of the front end file, and all users are sharing that file via shortcuts, then you have a disaster waiting to happen.

Additionally, you should keep a master design copy of the front end on your PC. If you need to make design changes, do so in this copy. When you are done, make a copy of this updated file and repace each users local copy with the new one.

Finally, the front end copies that you give each user should be .accde (or .mde) files, not .accdb (or .mdb) files. Look under Database Tools to make a accde/mde.

 

[kjh]

Ok I understand now. Thanks for your help. I did not fully understand the terms front end and back end till now. I will get to work on setting it up correctly. Thanks again.