none
Can't delete some records in table RRS feed

  • 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.

    Saturday, September 26, 2015 2:14 PM

Answers

  • 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.

    • Marked as answer by yellowparrot Saturday, September 26, 2015 11:41 PM
    Saturday, September 26, 2015 3:18 PM

All replies

  • 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.

    • Marked as answer by yellowparrot Saturday, September 26, 2015 11:41 PM
    Saturday, September 26, 2015 3:18 PM
  • What is the total size of your database file?  Is your database split into a front-end / back-end structure?
    Saturday, September 26, 2015 3:19 PM
  • 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.
    Saturday, September 26, 2015 5:34 PM
  • Thanks so much. It's work. Very simple: Compact and repair solved my problem!

    • Proposed as answer by ryguy72 Sunday, October 11, 2015 1:34 PM
    Saturday, September 26, 2015 11:36 PM