Can't delete some records in table

Question

I've met a serious problem with a table with 32522 records. At first I can't run query with this table. Then, I found that it had some records can't be delete. One of them is blank record (all fields are blank), others have strange value like chinese char in some fields.

Please help me! Thanks for reading.

Answer 1

First of all: Make a backup.

Looks like data corruption. Run Compact and repair. When it's still defec, create a new database and import only that table. When it still is corrupt, then look for an older backup.

Otherwise use VBA. Open a recordset from that table and push row for row into a new table.

Answer 2

What is the total size of your database file?  Is your database split into a front-end / back-end structure?

Answer 3

The strange characters can be caused by a memo data type being used in a query where you have fields with expressions, Sums, Counts etc. Memo fields behave very erratically in these queries and show what looks like cryptic characters. So find any queries with memo fields first. Then in design mode make sure the the Sum (Sigma) button is not checked. You may have to remake any of the queries or remove the memo fields from them.

Answer 4

Thanks so much. It's work. Very simple: Compact and repair solved my problem!