Help Please -- Record Lock

[TheRealDeal]

I am trying to update a record that is locked in Access. I can navigate to the record in question and change any field, but when I step out of the record it gives me an error and will not accept the changes. I have the recordset on a Novell network and am the only person accessing it. I have been able, historically speaking, to modify data in a recordset after 24 hours when file locks resets, but this time an individual record is locked. What do I do? I am not able to get beyond this within the existing MDB.

 

[lameid]

As with everything Access troubleshooting, backup before getting started.

Try a compact / repair.

If a databasename.LDB file exists after everyone is out, try deleting it and then a compact / repair. Make sure that when the LDB file is created that you can read, write and delete it. Under Windows server, files inherit permissions from the folder so setting the appropriate permissions on the folder should work. I don't know about Novell.