[AccessD] Linked Table Limits?

Hi all,

 

Does anyone know if there are limits to the number of linked tables (to
a SQL database) that can be included in an Access query?  I have a query
that joins (2) linked tables and (2) local Access tables.  That runs
very fast.  However, if I try to add one more linked table to the
query.....it simply crashes the database.  I've even tried using a sql
select statement in the query, to get the data from that last linked
table......crashes the database.  IF I copy the entire linked table to a
local table, and then select/join to that table......the query runs
fast.  When I try exporting the query, with the select statement to the
linked table.....my resultant export (incomplete due to the crash) is
corrupted.

 

So, my question is....is there some sort of limit to the number of sql
tables that I can join, in a query?  There doesn't seem to be anything
wrong with the sql table I am trying to join.  Just very odd.

 

Thanks,

 

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-2136 fax | www.rtkl.com
<http://www.rtkl.com/>