#Error in table record - cannot delete

G

Guest

I have a record in a table that displays #Error in every field. Whenever I
click in any field I get repeated "Invalid Argument" errors. I cannot delete
the record. Any ideas?

Thanks for your help!
 
G

Guest

At times like this, nothing beats a good backup. In fact make a complete
backup of your database now and put it away for safe keeping.

Then try doing a compact and repair. If that doesn't work, check out the
links below.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp
 

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

Similar Threads

DELETE FROM a table WHERE... 1
Invalid Argument - Cannot Delete Record 1
Cannot delete #error on one record. 5
Delete record with #error in every field 1
When try to delete record, required field can't be null 3
Unable to delete record with #error 2
How to delete a record with all fields = #Error? 3
Error 3201 You can't add or change a record...when delete/deleting 2

Top