Hello Experts! I'm getting an error "Could not update, currently locked" with my database; however, the error is extremely intermittent. With about 30 users, we may see the problem after 1 day or two weeks or more. The error remains for about an hour unless I ask all user to log out of the database and get back in. Here are more particulars:
I have a front-end Access 2003 db with the forms. The tables are linked to the back-end db (access 2003 format also). We are running Windows XP (SP2) on a large network. The database (both front-end and back-end) reside in the shared network directory. Users are using a form with the main table and a sub-form to add/update/view a "notes" table (ID, Case Number [indexed and allows dups, links to main table], date and note - a memo field). The notes table in the sub-form is opened as a query so that entries are sorted by date.
When the error occurs, users will be sitting in the sub-form waiting for the cursor to move. I found that if I open the back-end db while the users are locked out, I am also locked out of being able to update the records in the back-end notes file directly. This seems to indicate that there is a record lock occurring I suppose.
I've been through the other postings for similar errors. I have "No Locks" selected for the main and sub-form so that optimistic locks are occuring. I have a one to many relationship defined between the main and notes table.
Any ideas where to look? Am I getting too many locks on the database itself? If so, how do I check this? Any other ideas???
Start Free Trial
