I get Invalid Argument message, record reads #Error, what to do?

[Guest]

One of the records in an Access database shows #Error in all the fields.
I get the "Invalid Argument" window message and I can't even delete the
record. Any suggestions on how to fix this problem.
Very much appreciated and Thanks in advance

 

[Guest]

Try TOOLS - Compact and Repair.

 

[John Vinson]

One of the records in an Access database shows #Error in all the fields.
I get the "Invalid Argument" window message and I can't even delete the
record. Any suggestions on how to fix this problem.
Very much appreciated and Thanks in advance

Your database is corrupt. You'll almost certainly need to create a new
..mdb file; import all the OTHER objectx. Import this table *design
mode only* - don't import the data, or you'll just corrupt the new
database!

Link to this database and then run an Append query to append all
records *except* this one. It's best to use range criteria on the
table's primary key to select records before and after (but not
including) this corrupt record.

See http://www.granite.ab.ca/access/corruptmdbs.htm for more
information about corruption in Access databases.

John W. Vinson[MVP]

 

[Guest]

Thanks Karl for your response.
I tried that already and then I get a different message due to a network
situation, so that option didn't help as it has in the past.
Thanks though.
Ben

 

[Guest]

Thanks John. I am going to try what you explained in your message.
I did get some similar suggestions but what they suggested was to export the
data, your message was more explicit and clear. Thanks.
Ben