[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1227
  • Last Modified:

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.
0
tesla764
Asked:
tesla764
1 Solution
 
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)PresidentCommented:
<<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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"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
 
tesla764Author Commented:
Thanks.
0
 
tesla764Author Commented:
Thanks.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now