error in table

[mrisher]

I have a table called sales_records that will not allow me
to do anything else in the database. I can't run reports
or anything because I keep getting "Invalid Argument" I
go to look at the table and I find that record 81474 has
#error in every field. When I try to click on the row, I
get a message box with INVALID ARGUMENT. I can't delete
the row, I can't repair and compact, I can't even migrate
the good data in to another database. I get Record has
been deleted. How can I repair this database and get rid
of this nuisance record?

 

[Duane Hookom]

I have created a new table with the same structure and then appended records
from the corrupt table into the new table. Make sure your append query
excludes the corrupt record. Probably the best site on the web regarding
corruption is Tony Toews http://www.granite.ab.ca/access/corruptmdbs.htm.

 

[John Vinson]

I have a table called sales_records that will not allow me
to do anything else in the database. I can't run reports
or anything because I keep getting "Invalid Argument" I
go to look at the table and I find that record 81474 has
#error in every field. When I try to click on the row, I
get a message box with INVALID ARGUMENT. I can't delete
the row, I can't repair and compact, I can't even migrate
the good data in to another database. I get Record has
been deleted. How can I repair this database and get rid
of this nuisance record?

This is due to corruption, possibly in a Memo field in your table. The
only solution I know is to create a new, empty database; recreate this
table DESIGN MODE ONLY, and run one or more Append queries to migrate
the data, using criteria (preferably on the Primary Key) which
explicitly do NOT select this record. This record is a poison pill -
touching it in any way will cause the query to fail.

You can then import the rest of the tables, forms, queries, etc.;
Compact the database when you're done.