Hello,
I have an Access 2002 database that is a split FE/BE application. All users are instructed (and I'm assuming they followed the instruction) to copy the FE to their desktops and paste (not shortcut). On the FE there is a data entry form (continuous form) where each of the users review information and code the case from a drop-down box. Clicking the drop-down box generates an after-update event that writes relevant case information (including a Now() function to indicate the date and time coded) to a performance tracking table.
Starting yesterday, a user received a "Can not update record; currently locked" error when they tried to code one of the cases. The data wrote through to the performance table fine, but the recordsource table for the form did not get updated with the coding. This kept happening until I checked the BE table to see who "owned" it via the .ldb file. Once they exited, everything went back to normal. This happened again today.
I'm puzzled. Users aren't workign the same cases, so it's not that they are coding the same case at the same time. I have the form properties set to No Locks and the Recordset Type set to Dynaset. There are approximately 2-4 users in at a time - and again, like I said, everybody only accesses their assigned cases. Any thoughts? I'm puzzled!
Jeremy