Question Bookmark problem #ERROR (2)

[Birdman895]

I am running an Access 2010 db, split and running on a small office network. I just found that one of my tables has this problem if I open it from the front-end. There are 26 records that have #ERROR in each field of the record. There are 155 records w/o any problems.
If I open the back-end and open the table there I have 155 good records only.
Does anyone know why this happens?
Should I stop using the db?

 

[pr2-eugin]

Try a Compact and Repair AFTER YOU create a BACKUP on both your Front end and Back end files.. For many cases I have found Compact & Repair a good solution.. Try it and see what happens..

 

[Birdman895]

Thanks for the pointer. I did a save-as to the back-end and then ran Compact & Repair on the back-end first, and then on the front-end. After that I was left with the one corrupted record and could delete it.
Thanks for your help!