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.
