Invalid Argument - Cannot Delete Record

[Guest]

I have a table with about 10k records. Somehow a record has become
"corrupted". Every field for the record shows #ERROR (including the primary
key which is AutoNumbered) and whenever the record is accessed all I get is
an "Invalid Argument" error message. I cannot delete, modify, edit or
anything else to fix the record. The rest of the table is fully functional.
Is there anyway to remove this unwanted record and do you have any idea as to
what may have caused this to happen to begin with.

 

[Arvin Meyer [MVP]]

When working with corruption always make copies of the database file first.

1. Try a compact and repair.
2. Try using JetComp.exe.
http://support.microsoft.com/default.aspx?scid=kb;en-us;295334
3. Try copying all the records except the bad one to a new table.
4. Try importing the tables into a new empty database.

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access