Error while opening table in data sheet view

[Newbie_Sashi]

Hi,
I am receiving an error message when I try opening an access table in data
sheet view. The error message is "record is deleted" and does not let me open
the table.
However, when I run a query it provides me some results. When I try
exporting the table to excel, I get the same error message and there are no
records in the exported excel sheet. Pls help.

 

[Arvin Meyer [MVP]]

It sounds like your table has been corrupted. First, always work on a copy
of the database. Working on the original may make it impossible for a repair
service to fix it.

Do a Compact and Repair

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

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

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[Newbie_Sashi]

Your the best...I was able to fix it with your tips...thank you very much.