Results 1 to 10 of 10
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Unusual happenings (2003)

    I don't really know if this is an Access problem, but here it is. We have a network database which I created. Just recently, when I try to open the database, I get the message, 'You do not have exclusive access to the database at this time. If you proceed to make changes, you might not be able to save them later'. If I click 'ok', the message appears again. This occurs about 8 times, and then I eventually get into the database. I could understand if the database was opened in edit mode, but it isn't. I also tried to open a form example I downloaded, which gives a message when you first open it that the forms in the database can't be edited. This has been protected by the creator, but again this message appears 8 times. Don't know if any one has any suggestions, but I don't know why this is happening.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Unusual happenings (2003)

    The message 'You do not have exclusive access to the database…' usually occurs when the database has already been opened by another user and you try to open a form or report in design view, not if you open a form in form view or report in preview mode. Do you have code that opens a database object in design view when the database is opened?

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Unusual happenings (2003)

    No. This is what is strange. This has never happened before. If I try to open the database in design view and someone is in, I get the message, but now I'm getting it just when I try to open the database.

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Unusual happenings (2003)

    Is this one database or split (frontend/backend), and does each user have a separate frontend copy?

    You might also try checking your Access settings to make sure the "Track Name AutoCorrect info" checkbox is cleared (from menubar, select Tools, then the General tab).
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Salem, Oregon, USA
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unusual happenings (2003)

    This problem happens (rarely, but occasionally) to us on a network, and the more I type this, the more wrong I think I must be in how it actually occurs -- but let me describe what I was first going to write, although now I'm not sure it works this way:

    Users A, B, and C have "modify" privs on the parent folder, where the database resides. These users have read & write privs to the database.
    Someone adds user D to have read privs on the database -- and also neglects to add them with "modify" privs to the parent folder (usually, giving them "read").
    That means that when a user A, B, or C opens the database, and then D access it, and then A, B, or C closes it, then when D is left, there privs don't allow them to delete the lock file, and subsequent users, even with modify privs, only seem to get read-only access the database. -- Once again, I am not sure now if the scenario I just painted is what actually occurs, but I know I solve the problem by deleting the lock file (and making sure all authorized users have "modify" privs to the folder, which makes locking down the rest of the folder a hassle, but there it is).
    thx
    Pat

  6. #6
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Unusual happenings (2003)

    All users need read/write/delete priviligles to the folder than contains the database.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  7. #7
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unusual happenings (2003)

    I don't know if relevant, but it caused similar problems to me once. Have you checked there is not (I think) an .ldb file of the database on the system, being an unclosed db caused by a error which was resolved and highlighted later doing a compile of the db code. Hope it's relevant.

  8. #8
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Unusual happenings (2003)

    Sorry I'm only just getting back to you all, but still trying to work out what's going on. I tried to log on to a database yesterday, when I knew most of the users should have been logged off. I still got the error message. Our IT guy tells me that no users privilieges have been changed, so I don't know what's going on. It looks as though the lock file is not being closed when some users exit the database.

  9. #9
    New Lounger
    Join Date
    Dec 2008
    Location
    Jacksonville, North Carolina, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unusual happenings (2003)

    Hello, I am new to this. My problem is this. I imported an excel file into access 2003 and created a form with the information. I can not figure out how to save this file to the server. I need help please!!

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Unusual happenings (2003)

    I see that you have reposted the question in <post:=755,920>post 755,920</post:>; I posted a reply there.

    (In the future, please ask questions only once <img src=/S/smile.gif border=0 alt=smile width=15 height=15>)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •