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!

Register Log in
  • 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 return blank results!?

Status
Not open for further replies.
KarlTrep

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
 
Sort by date Sort by votes
If these queries worked before the compacting, you may need to run a repair on Access. Otherwise, check each query statement. Access may have lost you criteria.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Brand new lock violations errors all over my database
Replies
11
Views
2K
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
663
TheresAlwaysAWay
TheresAlwaysAWay
TheresAlwaysAWay
  • Locked
  • Question
Can not get Access 2016 queries to accept form value input or TempVars! input 2
2
Replies
21
Views
675
TheresAlwaysAWay
TheresAlwaysAWay
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
507
JimStrand
JimStrand
Hanss
  • Locked
  • Question
Query which shows results?
Replies
2
Views
194
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top