[AccessD] Linked Table Limits?

I don't know if there is a limit, but I have a database which nearly all the tables (150+, 2 of which contain over 200,000 records) are linked from SQL Server, and I have a query that links 8 of them with no problem whatsoever......


Paul Hartland



Message Received: Feb 08 2007, 03:16 PM
From: "Keith Williamson" 
To: "Access Developers discussion and problem solving" 
Cc: 
Subject: [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




-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





Paul Hartland
paul.hartland at fsmail.net
07730 523179