Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

All Queries now return blank results!?

Status
Not open for further replies.

KarlTrep

Technical User
Oct 30, 2000
5
CA
After compacting an access 2000 database, all queries now return blank results when ran. Same as if you left the prompted criteria field blank. Anyone know what's up with this? Really need the help.
Thanks
 
Karl,

I ran into the same problem (or one that sounds similar) a while back and here's the problem. Your database sounds like it's corrupted.

1. Close your database
2. Open a new blank database.
3. Choose "Get External Data" from the File Menu
4. Import your old database into the new one.
5. Choose select all on all tabs of the import dialog.

Your new database is now an exact copy of the old one and the corruption should get cleaned out during the import.

Good Luck,

Grant.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top