Results 1 to 2 of 2

Thread: Locked

  1. #1
    Join Date
    Nov 2005

    Unanswered: Locked

    I have a database that I want multiple people to be able to access and read from at the same time and I am getting the error
    "Could not lock table “dbname”; currently in use by user “Admin” on machine “computerxx”."

    How do I tell the form to unlock the DB immediately or allow multiple people to access it at once.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    check the lock settings for your database. Depending in the version of Access you use you shoudl consider 'record level' locking (A2000 on) or optimistic locking (earlier versions) - if you use optimistic locking (ie none) then you need to consoder how you will deal with write conflicts - ie where one person makes changes to data and someone else makes changes in the same timeframe.

    tools | options | advanced

    should do the trick
    whilst youare there make sure the default open mode is shared NOT exclusive

Posting Permissions

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