one record in a table with #Error in every field

[Guest]

Hi
I am developing a fairly large program with split data and programs. Due to
go live within the month. In one table while user testing a record has been
created with #Error in every field and which makes the whole table useless.
It will not allow the record to be deleted as it appears to be locked yet
all users are out of the system
The table can not be re created with a Make Table query
It is one of the main tables with approx 10 relationships from it.
Please has anyone any idea what has caused the problem and how to get over it?
Many thanks in advance

 

[Allen Browne]

Break the relations.
Replace the table with a new blank one.
Populate it with all the *other* records.
Delete the old table.
Compact the database.
Rename the new one to the old name.
Recreate the relations.

More info in symptom 3 of:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html

 

[Guest]

Many thanks Allen
I am trying what you suggest now and the extra info from your web link

 

[Guest]

The same thing happened to me just the other day. All I did was I copied all
the records except the row that had errors and pasted the infor in aspread
sheet as a backup, then I compacted the backend and I was able to select the
row with issues and delete it. Its old style but it worked for me .... all
the best!

OJ!