SQL Limitations

  • Thread starter Thread starter Ryan L. Schoolman
  • Start date Start date
R

Ryan L. Schoolman

I was wondering if there is a limit to how many Joins you can have in a
query? The reason why I ask is that I am receiving no current record error
message.


--
Ryan Schoolman - Programmer & Application Architect
(e-mail address removed)

Infinity Software Solutions Inc.
http://www.infinitejoy.com

[w] 715.839.6855
[c] 715.379.0878
[h] 715.855.9003
 
I was wondering if there is a limit to how many Joins you can have in a
query? The reason why I ask is that I am receiving no current record error
message.

Check the online help for Specifications - I think in practice you'll
get the Query Too Complex error before you hit any limit on joins.

One thing I would NOT expect is to get a "no current record" error
because of an excessively large query! Are you sure there IS a current
record? If you have many INNER joins, you're aware that every single
table must have matching values in order to get any record shown? I
hesitate to suggest that you post the SQL if it's that big, but maybe
someone could spot a problem if you did so.
 
"no current record error message" does not sound like a Query error. Are
you using the Query as the RecordSource for a Form and you get this error on
the Form? In this case, try opening the Query by itself, not through the
Form and see if the Query returns any row.

You can have 32 Tables in a Query and you can have (quoted from Access Help)

"32 {enforced relationships} per table minus the number of indexes that are
on the table for fields or combinations of fields that are not involved in
relationships."

My guess is that we would be very confused well before we reach the limits.
 
Back
Top