Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Elkins Park, Pennsylvania, USA
    Posts
    325
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Locked Record? (Access XP)

    Hi, all. I've wandered over to this forum to post my latest problem in my role as fireman here at work.

    I own a relational database used by our word-processing department. It uses a one-to-many approach to link records (with detailed information about individual Word files) to records of jobs submitted by users. For viewing and editing purposes, each job is displayed in an individual (non-continuous) form. This form also contains an embedded form (in table-layout format) that lists all documents for that job. The database is split into a front end that is installed on the user's desktop, and a back-end that resides on a file-server.

    Now, for this one particular record, the sub-form lists a particular document twice (technically allowed, but realistically it's probably a mistake). Furthermore, it indicates that one of those instances is locked. If I go into the "Jobs" table (the "one" table), it doesn't show the icon indicating that the record is locked, but if i try to edit the record, it does report that it's locked. Similarly, if I go into the "Documents" table (the "many" table), the record for the document in question does not show a "locked" indicator, but when I try to change the record, I get the same result (i.e. I can't save it because it's locked).

    I tried creating a new "document" record (because it seems to be the most fundamental place to start), but I can't modify the record for the job in order to add the new document because... you guessed it.

    What can I do? What should I look for? I'm waiting for everyone to "get out" of the database so that I can rebuild it; hopefully that will help.
    <font face="Comic Sans MS">That's what you do in a herd; you look out for each other!</font face=comic> - Mike

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Locked Record? (Access XP)

    Hi! Have you tried deleting the temporary file (.ldb) from the server? You'll still have to wait for everyone to get out, but that usually clears everything up for me.

Posting Permissions

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