Unable to delete record with #error

[Cliff Brooks]

Somehow, some invalid data was entered into a field in one
record. That record now displays #error in every field.
I an unable to delete the record because I get an "invalid
argument" error message whn trying to work with the
record. Any suggestions for deleting it?

 

[Van T. Dinh]

It is a sign of corruptions. Try:

1. Create a new database.
2. Import all Access objects (structure AND data for Table) except the
Table with the corrupted Record.
3. Import the above Table but use "Structure-Only" option.
4. Use an Append Query to append all good Records from the start to the
Record just before the corrupt Record.
5. Manually enter the corrupt Record if you have some details of this
Record.
6. Import the remaining good Records.
7. Open any code module and do a Compile command.

 

[Charles Panganiban]

-----Original Message-----
Somehow, some invalid data was entered into a field in one
record. That record now displays #error in every field.
I an unable to delete the record because I get an "invalid
argument" error message whn trying to work with the
record. Any suggestions for deleting it?
.

hi Cliff,

instead of trying to delete the single record, why don't
you try creating a new table excluding the record with the
#error.

Good luck, and may the force be with you

Charlie