Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: You do not have exclusive access to the database. ms access 2003  (Read 1216 times)

0 Members and 1 Guest are viewing this topic.

Deon

    Topic Starter


    Rookie

    Thanked: 1
    • Experience: Beginner
    • OS: Windows 8
    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

    Allan

    • Moderator

    • Mastermind
    • Thanked: 1195
    • Experience: Guru
    • OS: Windows 10
    Re: You do not have exclusive access to the database. ms access 2003
    « Reply #1 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

    Deon

      Topic Starter


      Rookie

      Thanked: 1
      • Experience: Beginner
      • OS: Windows 8
      Re: You do not have exclusive access to the database. ms access 2003
      « Reply #2 on: March 30, 2017, 02:10:23 AM »
      Thank you, I have done that setting. problem still persists.

      BC_Programmer


        Mastermind
      • Typing is no substitute for thinking.
      • Thanked: 1069
        • Yes
        • Yes
        • BC-Programming.com
      • Certifications: List
      • Computer: Specs
      • Experience: Beginner
      • OS: Windows 8
      Re: You do not have exclusive access to the database. ms access 2003
      « Reply #3 on: March 30, 2017, 04:51:21 AM »
      Perhaps you need to run Access as Administrator?
      I was trying to dereference Null Pointers before it was cool.

      Allan

      • Moderator

      • Mastermind
      • Thanked: 1195
      • Experience: Guru
      • OS: Windows 10
      Re: You do not have exclusive access to the database. ms access 2003
      « Reply #4 on: March 30, 2017, 05:27:49 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.

      Deon

        Topic Starter


        Rookie

        Thanked: 1
        • Experience: Beginner
        • OS: Windows 8
        Re: You do not have exclusive access to the database. ms access 2003
        « Reply #5 on: April 08, 2017, 11:45:15 AM »
        thanks. I tried that. I have gone back to office 2010. Thank you. Goodbye