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

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top