• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 978
  • Last Modified:

Access 97 query: 'Reserved error (-1601)' problem

I have discovered blank records in one of my database's tables which I cannot delete/cut/clear or do
anything else with! Each time I try to do anything with them the following message appears:
'Reserved error (-1601); there is no message for this error.'
Although these records are blank they appear to be contain some data as when I sort the table they do
not all cluster at the top or bottom but are listed with other relevant records for the same link field.
Can anyone help?
Thanks.
0
djmarsh
Asked:
djmarsh
  • 2
  • 2
1 Solution
 
VolibrawlCommented:
1. Compact and repair DB - From tools/database utilities menu.
2. Index might be corrupted, remove index from table then re-index.
0
 
VolibrawlCommented:
If the above attempts fail:

1. Try appending the "good" records to a new table.
2. Try importing the existing table to a new mdb.
0
 
devthaCommented:
corrupted table. Try to export all objects to new db and recreate this table.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Outside of what's already been suggested, you might want to give JETCOMP.EXE a try.  It's a standalone compact/repair utility available from Microsoft's web site.  Depending on what in the MDB structure is corrupt, it may work when the other methods don't.

HTH
Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
That should have been "it may work if the other methods don't".  I didn't mean to imply that the other methods suggested would not work.

Jim.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now