Limitations on a Query when linking tables

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

Guest

I am running Access 2003, linking my tables (on the server) to a .mdb on my
computer. When running a query linking several tables, the query only
displays 63557 records. How do I fix it?
 
On Wed, 5 Oct 2005 06:21:04 -0700, Jan Gouws <Jan
I am running Access 2003, linking my tables (on the server) to a .mdb on my
computer. When running a query linking several tables, the query only
displays 63557 records. How do I fix it?
Click to expand...

By correcting the error in your query.

There is no limit to the number of records returned by a query. If
you're seeing 63557 records, that's because those are the records
which match the criteria on your query (or perhaps because you're
looking at the results in some way that is not giving Access time to
traverse the entire recordset).

Are you certain that there aren't tables included in Joins which have
no data for some records? You could post the SQL and someone might be
able to spot the problem.

John W. Vinson[MVP]
 
Back
Top