Deleted record?

[Guest]

Hello,

I have a strange problem that I' hoping someone can explain to me how it
occurs so that I can't stop it from happening again.

In one of my tables a recordset (row) has been "deleted" but instead of
being removed from the table altogether, the value "deleted #" has been put
as a value in each field of the recordset... even the autonumber which is
supposed to only accept integer?

Could someone explain this at all!?

Thank you!

Dan

 

[John Vinson]

Hello,

I have a strange problem that I' hoping someone can explain to me how it
occurs so that I can't stop it from happening again.

In one of my tables a recordset (row) has been "deleted" but instead of
being removed from the table altogether, the value "deleted #" has been put
as a value in each field of the recordset... even the autonumber which is
supposed to only accept integer?

Could someone explain this at all!?

Try Tools... Database Utilities... Compact and Repair.

If this data is stored in an external database (dBase, SQL, or other)
you may need to do some sort of compaction in that database's
software. Normally a local Access table doesn't display the #Deleted
message, or only briefly if it does.

John W. Vinson[MVP]

 

[BillB]

The only one time I had this happen it turned out to be a corrupt database
file.

Bill