How can I get rid of #Deleted in my table fields

[Guest]

Someone had gone in and deleted data from a table. When they did two rows
now have #Deleted in all fields. I have tried to remove both rows by going
through ajd deleting them. Access tells me that data is being deleted and
will go ahead and delete the rows when I say ok. However, when I reopen the
table those two rows with the #Deleted in all fields returns.

Is there a way to remove these two rows or get rid of the #Deleted in the
fields so that I can re-enter my data?

 

[Dirk Goldgar]

Someone had gone in and deleted data from a table. When they did two
rows now have #Deleted in all fields. I have tried to remove both
rows by going through ajd deleting them. Access tells me that data
is being deleted and will go ahead and delete the rows when I say ok.
However, when I reopen the table those two rows with the #Deleted in
all fields returns.

Is there a way to remove these two rows or get rid of the #Deleted in
the fields so that I can re-enter my data?

That sounds like you may have a corrupted index. First see if clicking
Tools -> Database Utilities -> Compact and Repair Database... fixes it.
(You must be the only one in the database at the time. And if this is a
split database, you have to do it in the back-end, not the front-end.)

If that doesn't work, have a look at Tony Toews' Currupt MDB FAQ page:

http://www.granite.ab.ca/access/corruptmdbs.htm

There's a lot of information about corruption there, including
procedures for recovering from it.

 

[Guest]

Thanks Dirk. I'll try your suggestion(s).

That sounds like you may have a corrupted index. First see if clicking
Tools -> Database Utilities -> Compact and Repair Database... fixes it.
(You must be the only one in the database at the time. And if this is a
split database, you have to do it in the back-end, not the front-end.)

If that doesn't work, have a look at Tony Toews' Currupt MDB FAQ page:

http://www.granite.ab.ca/access/corruptmdbs.htm

There's a lot of information about corruption there, including
procedures for recovering from it.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)