Delete record with #error in every field

A

appr8z

Hello I'm very new at using access. In our database we have one record that
has #error in every field, including the autonumber field. how can I delet
this record. when I tried the staus bar msg says I cannot because it is bound
to the autonumber. I am unable to generate any reports because I always get
the error msg "invalid argument"
 
K

Ken Snell \(MVP\)

That data record is corrupted. Make a copy of the database right away.

You'll need to import all the tables and other objects into a new database
(create new database, click on File | Get External Data ... | Import) and
see if you can extract all the other data except for that corrupt record.
 

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

Copy previous record into form field 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
2007 Access Engine Deleting Records 0
How to delete a record with all fields = #Error? 3
#Error in table record - cannot delete 2
Delete first record error with linked tables 7
"Compile error in table level validation expression " after format 0
When try to delete record, required field can't be null 3

Top