error in table

  • Thread starter Thread starter mrisher
  • Start date Start date
M

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?
 
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?
Click to expand...

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.
 
Back
Top