MS Access 2010 - do not have exclusive access to the database at this time

Microsoft Access error encountered when attempting to make changes to forms and macros...
"You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later."

In our Freight Tracking database, when it was Access97, I had the ability to update forms and macros regardless of other users being in the database. Now with Access2010 I do not. I get a pop-up window (see below) advising that I am not an exclusive user and that any changes made will not be saved.
Now in Access 2010 when I attempt to make form and macro changes I get the message...
"You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later."

Is there a way around this? I make changes to forms and macros on a regular basis and having to wait until everyone else is out of the database is not practical. Can you please look into this for me.

I had no problems doing this in Access 97.

Any answers or suggestions would be greatly appreciated.
Thanks.
tesla764Asked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"that you alone work on and when changes are ready, distribute them to the users."
And to help you do the distribution and management ... you will want this:

http://www.autofeupdater.com

This used to be free, but ... Tony added a LOAD of cool new features, so ... time to recoup some development $$$$

mx
0
 
Helen FeddemaCommented:
Make sure that all the users are opening the database in shared mode.

BTW, if you have just made the huge jump from Access 97 to Access 2010, more than likely there are a good deal of code changes that need to be made.  I am attaching a document with some of the likely changes that are needed.

Updating-a-Database.doc
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Is there a way around this? I make changes to forms and macros on a regular basis and having to wait until everyone else is out of the database is not practical. Can you please look into this for me.

I had no problems doing this in Access 97.
>>

  No, no way around.  Since A2000 it is only possible for one user at a time to make design changes to a DB.  This was done to avoid corruption in the VBA project file.

JimD.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

BTW, what you'll need to do is keep a "master copy" that you alone work on and when changes are ready, distribute them to the users.  This also assumes your using a split design; a front end with everything but tables and a back end with only the tables.

Distribution can be accomplished with one of the many "launcher" or "auto updaters" available or a simple batch file.

JimD.
0
 
tesla764Author Commented:
Thanks.
0
 
tesla764Author Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.