Delete record with #error in every field

G

Guest

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

How to delete a record with all fields = #Error? 3
Delete first record error with linked tables 7
#Error in table record - cannot delete 2
Record Deletion 3
#ERROR in TABLE 4
Unable to delete record with #error 2
restore a deleted record in table with autonumber field 2
When try to delete record, required field can't be null 3

Top