Run a query filters some records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have multiple users using one Access database to log bugs. Sometimes after
I run some queries, a lot of records disappear when viewing the form.
However, I can see all the records are still in the table where all the data
restored. Compact&repair database doesn't help. To have all the records back
in the view I need to copy all the data to a back up database.

Why is it happening?
 
Maybe there is a filter active that filters out some record? maybe there is
a limit on the number of records displayed?


Vanderghast, Access MVP
 
Back
Top