Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Location
    Wichita, Kansas, USA
    Posts
    177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Shared access (Access 2000)

    Okay, I have a company user of a shared Access 2000 database. She has been set up with editing privleges of this database. When she is trying to go in and create a new macro for this database, she is getting the standard 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, blah blah blah...etc." I know that this message usually comes up when someone is trying to edit a database that someone else has open. But we have made sure everyone else has it closed (even tried it after hours) and I have checked the server log itself, which shows me this user is the only one with the database file open. However, she still gets this message, so she can't edit in design view or create macros.

    Am I missing something here? Why else would this message appear?

  2. #2
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shared access (Access 2000)

    Try opening Access and locate the db to be opened.

    Before actually opening, the open button has an arrow enabling you to open the button.
    Pick the Exclusive option.

    If this doesn't work, check for any orphan ldb files.

    Or try to copy the db to a local machine and change the design from there. Paste it back afterwards.
    Make sure you have a backup if things go wrong.

    Dave

  3. #3
    2 Star Lounger
    Join Date
    May 2001
    Location
    Wichita, Kansas, USA
    Posts
    177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shared access (Access 2000)

    Dave,
    Sorry so long to reply -- but thanks for your help. What you suggested worked for us. Thanks again.

Posting Permissions

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