Error message: Record is Deleted

[Debbie]

I must have hit a button or something that I am unaware
of either in the datasheet view of a query or a table.
When I try to open one particular table I get the
message, 'record is deleted' with only the option to
select 'ok'. Then after clicking 'ok' another message
states 'Microsoft Access can not open this table in
datasheet form' (or something to that affect). I can
open is in design view, but not datasheet. What's up? I
hope I am not losing all of my work!!!!

 

[Allen Browne]

Hi Debbie. Your database is partially corrupt, but there are several things
you can do to retrieve some/all data.

1. First, make a backup copy of the mdb file while Access is not running,
and without overwriting any other backups you have.

2. Next, open the database, and try a repair:
Tools | Database Utilities | Compact/Repair

3. If that doesn't work, see if you can fix a corrupt index.
Open the relationships window:
Tools | Relationships
Delete any relations between this table and any others, by
right-clicking the lines joining the tables and choosing Delete. Then click
the "Show All" button on the toolbar (or View menu), and verify that there
are no more relations left.

4. Now open the table in Design view.
Open the Indexes (View menu).
Delete any indexes, including the primary key.
Save. Close the table.
Repair again.
If the table is fine now, you can rebuild the indexes and relations.

5. If you are still stuck, try importing into a new database.
Create a new (blank) database.
In the database, disable the Name AutoCorrect options under:
Tools | Options | General.
Import the table from your old database:
File | Get External | Import
If that works, you can import all the other objects as well.

6. If that also fails, try deleting your memo fields.
(This could rescue the rest of the data.)
Open the table in design view.
Delete any fields of type Memo, Hyperlink, or OLE Object.
Save and close the table.
Compact (Tools | Database Utilities | Compact).

 

[Debbie]

Allen-

Thank you so much. Just compacting and repairing the
database was enough to do the trick. Thank you so much
for all of your instruction!!!

Debbie - Los Angeles, California.....

 

[Allen Browne]

Great news!