How do I delete a record with an "invalid arguement" error?

P

PStorm7

I have one record in my database that has "#Error" in every field. I cannot
seem to delete the record nor can I create a query or report because of the
same message - "invalid arguement". How can I get rid of this one record or
correct the database so I no longer get the "invalid argeument" response?

thanks,
Pat
 
J

John Vinson

I have one record in my database that has "#Error" in every field. I cannot
seem to delete the record nor can I create a query or report because of the
same message - "invalid arguement". How can I get rid of this one record or
correct the database so I no longer get the "invalid argeument" response?

thanks,
Pat
Click to expand...

The database is corrupt and needs to be fixed pronto.

See http://www.granite.ab.ca/access/corruptmdbs.htm for a lot of
information which may help.

In this case, you'll need to create a new, empty database; import
everything *EXCEPT* this table. Import this table's design only, then
link to it and run one or more Append queries (using the primary key
of the table to select ranges which do not include this damaged
record) to transfer the data.

Good luck!

John W. Vinson[MVP]
 
Top