#Error on some fields of record - repair did not fix

[marydoyle9]

I have a table - apparently two users were accessing the same record at the same time (someone turned record locking OFF). The record now has #ERROR in some but not all fields of the record. I ran a REPAIR but nothing happened. If I try to access the record using a query, I get error messages and Access shuts down.

I have since gone in and set the lock to edited records so hopefully this own't happen again. Bt.. what can I do about the corrupted record?

Thanks!
Mary

 

[DBL]

You could try creating a new blank database and importing all the information from the existing one in to the new one. Remember to take any custom menus or toolbars too. If I remember correctly, when this happened to me, I had to delete the Error records as nothing would restore them but I couldn't access them until I'd imported all the data into a clean database.

Have you split your database in to frontend and backend? If multiple users are accessing an unsplit database then that might be more of an issue than the record locking levels. You are more likely to corrupt the database if it's not split but has multiple users.

I normally split the database and give each individual user a local copy of the frontend, linked to the common backend.

 

[marydoyle9]

not sure what you mean...

by split the database?

 

[DBL]

There's a function within Access where you can split your database in to two parts, Tools>Database Utilities>Split Database (A2K) It puts all the tables in to a database of their own (backend) and all the queries, forms, macros etc, are kept together (frontend). The frontend is then linked to the backend tables. If you search the forum there's mountains on this topic and it's certainly the way to go if you are using the database in a multi-user environment. Access Help should give you some information too.