Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Earth | North America | United States | California | Long Beach

    Unanswered: Access.Lockfile Question

    Is there a way to unlock a database when there is a Lockfile? This lockfile is dated from last Friday and I am certain that no one is in the database now.

    Additionally, is there a way to tell which machine caused the lockfile?

    Any help would be greatly appreciated!


  2. #2
    Join Date
    Oct 2003


    The presence of a lockfile is no problem at all. If no one is using the database you can delete it but "why bother."

    The way that MS-Access does locking is quite interesting. It takes advantage of the fact that the operating system allows you to lock byte-ranges in a file even though there is no such data in the file. I could for example lock byte number 1,234,567 in a file that contains .. nothing.

    Access puts almost nothing at all in the lock file, but has a rigorous and well-defined structure for the various ranges of byte-addresses that are used in the lock protocol. (e.g. say "if byte #12345+X is locked, then it means that record #X is locked").

    It's a really cool system if the network operating system that you're using is totally cool and totally working on the lock-protocol, and if every workstation really does get absolutely-correct results from all those lock-requests...
    ChimneySweep(R): fast, automatic
    table repair at a click of the

Posting Permissions

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