"#Error" displayed in one record in table. "Invalid argument"

[Guest]

Hi. I seem to be having a problem with a database. We can open the table,
but if we try to sort by any field, we get an "invalid argument" message.
Looking through the table itself, there is one record that has "#Error" in
every field. I am presuming this is causing the error, but I can't deliete
that record. Any ideas?

 

[Larry Linson]

Hi. I seem to be having a problem with
a database. We can open the table,
but if we try to sort by any field, we get
an "invalid argument" message. Looking
through the table itself, there is one record
that has "#Error" in every field. I am
presuming this is causing the error, but I
can't deliete that record. Any ideas?

This is a form of database corruption. You need to create a new, empty
database and copy all the other objects into it, except this table. Then, in
this new database, create a table identical to the one with the error,
except empty. Then copy in this table up to the record before the "#Error"
record, and then copy the records that follow the "#Error" record.

Larry Linson
Microsoft Access MVP