Computer Hope

Software => Computer software => Topic started by: Deon on March 28, 2017, 10:05:33 AM

Title: You do not have exclusive access to the database. ms access 2003
Post by: Deon on March 28, 2017, 10:05:33 AM

Hi, I installed windows 7 prof, and then I installed ms office 2003. Now I am creating databases. I have never got this messages before when installing ms office 2003 on win wp. When I code and make changes, this message pops up. "You do not have exclusive access to the database as this time. If you proceed to make changes, you may not be able to save them later." how do i get rid of it? Thanks. Deon

Title: Re: You do not have exclusive access to the database. ms access 2003
Post by: Allan on March 28, 2017, 10:13:58 AM

I can tell you how to change the setting in Office 2010 (I don't have access to Office 2003, so you'll have to hunt around in OPTIONS):

FILE - OPTIONS - CLIENT SETTINGS - ADVANCED - DEFAULT OPEN MODE
Make sure it is set to Exclusive and not Shared

Title: Re: You do not have exclusive access to the database. ms access 2003
Post by: Deon on March 30, 2017, 02:10:23 AM

Thank you, I have done that setting. problem still persists.

Title: Re: You do not have exclusive access to the database. ms access 2003
Post by: BC_Programmer on March 30, 2017, 04:51:21 AM

Perhaps you need to run Access as Administrator?

Title: Re: You do not have exclusive access to the database. ms access 2003
Post by: Allan on March 30, 2017, 05:27:49 AM

Quote from: Deon on March 30, 2017, 02:10:23 AM

Thank you, I have done that setting. problem still persists.

Well, then I'm at a loss. The only reason you should see that message is if file access is shared.

Title: Re: You do not have exclusive access to the database. ms access 2003
Post by: Deon on April 08, 2017, 11:45:15 AM

thanks. I tried that. I have gone back to office 2010. Thank you. Goodbye