Number of tables related in a query

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

Guest

Is there an inherent limit to the number of tables you can relate in a single
query?

Also, does the number of tables in the query affect the speed at which a
form retrieves data from the query? It looks like my forms retrieve data from
a query more slowly when the query contains less tables?
 
Marion said:
Is there an inherent limit to the number of tables you can relate in
a single query?
Click to expand...

The help in Access 97 indicates 32 maximum tables in a query. Not sure if the
newer versions have changed that.
Also, does the number of tables in the query affect the speed at
which a form retrieves data from the query? It looks like my forms
retrieve data from a query more slowly when the query contains less
tables?
Click to expand...

Of course. Having to figure out the joins and such is one of the higher demands
that a query imposes on the engine. There is not a completely linear
relationship between table count and query speed, but in general adding tables
adds complexity.
 
Marion

Check Access HELP with the key word "specification" for a list of the
"limits".

Are we talking about 2 tables or 20? Are your tables indexed on the fields
that you use for joining them together? ... on the fields you use for
criteria?

Are you working with a split database? ... over a LAN? ... at what speed?

Which version of Access?
 
Back
Top