In Access 2000 I see the error "#Error" in every field of a recor.

[Guest]

Access will not allow me to open the data base in datasheet view. I have a
record with the #Error message in each field.

Access will not allow me to delete the bad record.

 

[John Vinson]

Access will not allow me to open the data base in datasheet view. I have a
record with the #Error message in each field.

Access will not allow me to delete the bad record.

Your database is corrupt, probably (though not necessarily) because of
a bad Memo field.

See http://www.granite.ab.ca/access/corruptmdbs.htm for some
suggestions. Basically for this one, you'll need to create a new
database, import everything BUT this table; import this table, *design
mode only*, and run an Append query appending all records except the
damaged one. You'll need to use a query on the Primary Key to isolate
the records. The damaged record must be reentered manually; it's gone
for good.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps