Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113

    Unanswered: Split dB (Exclusive Rights issue)

    Hi,

    I have a database that is on a shared directory on a network. The database is split. There is only one workstation that is not able to access the DB and receives a
    Code:
    "You do not have exclusive access to the DB at this time.  If you proceed to make changes, you may not be able to save them later."
    All the workstations are on XP, Office 2003.

    The Access program is in Access 2000. I checked on the Workstation that can not access the DB Tools--> Options --Advanced and it is set to shared.

    I have another DB and it is also receiving the same error message on the same workstations.

    I looked at the permissions and he does have full control to the folder.

    Any ideas?

    Thanks
    ======================
    Levent
    Access 3

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Is there an *.ldb file knocking around near the access files (FE or BE) when you're not in the program?
    George
    Home | Blog

  3. #3
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113
    On the back end there is an ldb file, only when the DB is opened. Nothing lingering around after it is closed.
    ======================
    Levent
    Access 3

  4. #4
    Join Date
    Dec 2005
    Location
    Lancaster PA, USA
    Posts
    33
    If you're not able to open it with the problem machine when no one else is logged into the back-end file I would log in with one of the working machines and do a compact and repair.

Posting Permissions

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