I have a database that is shared by 5 people.
In one of the main tables that includes autonumbers, I have a record with #Error in one of the fields. Whenever I try to alter the field, I get a message saying "Record is opened by another user".
This always happens, even when I am the only one accessing the database.
I cannot import or export this table as I always get the above arror.
I have run repair, which completed successfully without fixing the problem and I have attempted to compact, which stalled, with a "no read permission" error.
Does anyone know how to fix it?