tesla764
asked on
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.
"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.
<<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.
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.
ASKER
Thanks.
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