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
