#Deleted Error

[Guest]

I have a record that was deleted by another user that does not seem to be
completly gone. When I access the table the record shows
#Deleted in every row. I can delete the record but it comes back when I
open the table again. It also will not allow queries to work that encompass
this record.

I have compacted the database and still the same. Any suggestions?

 

[Susie Johnson]

I'd reccomend using a reliable database, like SQL Server and Access Data
Projects

 

[Guest]

Create a new MDB and import all the tables to that MDB, check if you still
got that delete records.

 

[Guest]

I imported the table and the [ #Deleted ] record went with the table tothe
new MDB.

 

[Guest]

If you tried Compact and repair (hopefully on the mdb where the table are
located in) and the import to another mdb, try this links which I found in an
earlier post given by Tom Wickerath

Recovering from corruption
http://allenbrowne.com/ser-47.html

Recover records from a corrupt table
http://www.mvps.org/access/tables/tbl0018.htm

How to troubleshoot and to repair a damaged Access 2002 or later database
http://support.microsoft.com/?id=283849

How to recover data from a damaged database table or a corrupted
database table in Access 2000, Access 2002 or Access 2003
http://support.microsoft.com/?id=247771


If you still have no joy, then a data recovery service, such as this one:
http://www.pksolutions.com/



--
Good Luck
BS"D

I imported the table and the [ #Deleted ] record went with the table tothe
new MDB.

Create a new MDB and import all the tables to that MDB, check if you still
got that delete records.

 

[IRS Intern]

DO NOT LISTEN TO THESE ****TARDS

IF YOUR DATABASE SUCKS BALLS AND IS NOT RELIABLE YOU SHOULD MOVE TO A
REAL DATABASE

If you tried Compact and repair (hopefully on the mdb where the table are
located in) and the import to another mdb, try this links which I found in an
earlier post given by Tom Wickerath

Recovering from corruption
http://allenbrowne.com/ser-47.html

Recover records from a corrupt table
http://www.mvps.org/access/tables/tbl0018.htm

How to troubleshoot and to repair a damaged Access 2002 or later database
http://support.microsoft.com/?id=283849

How to recover data from a damaged database table or a corrupted
database table in Access 2000, Access 2002 or Access 2003
http://support.microsoft.com/?id=247771

If you still have no joy, then a data recovery service, such as this one:
http://www.pksolutions.com/

--
Good Luck
BS"D

I imported the table and the [ #Deleted ] record went with the table tothe
new MDB.

"Ofer Cohen" wrote:

- Show quoted text -