#Error in Table Field

[SteelersFan]

Our company Access database got screwed up today. I did the normal /repair to try to fix it and it the repair came back that it had successfully repaired the database. I did a compact and it came back with an error message at the end about not having rights to the database ( I was logged in as the administrator with full rights to everything). I then download the jetcomp.exe program on the MS web site but that didn't fix the problem.

When I started to investigate the problem, I noticed that the last three records in one of the tables had #Error in the same field. I deleted those records and that fixed the problem.

Question 1. If a field has #Error in it in the table view, doees that pretty much mean that record is fubar?

Question 2: Why did the Microsoft repair utility say it successfully repared the database and it still have errors.

 

[Len Boorman]

Record with #error does indeed mean SNAFU

Generally occurs when multiple users have tried to update/add same record.

Record locking strategy is required. Check all edit form properties Record Locking and make sure it says Edited Record

Repair facility will not fix this type of screw up

Len