artful at rogers.com
artful at rogers.com
Thu Feb 8 10:13:21 CST 2007
If memory serves, you cannot use more than 20 tables in a single query. I'll double-check that but I'm fairly sure that's the limit. Arthur Fuller Technical Writer, Data Modeler, SQL Sensei Artful Databases Organization www.artfulsoftware.com ----- Original Message ---- From: JWColby <jwcolby at colbyconsulting.com> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Sent: Thursday, February 8, 2007 10:28:48 AM Subject: Re: [AccessD] Linked Table Limits? Hmmm... I think something else is going on. AFAIK you can have every table in your database be out in SQL Server and thus you could have dozens of SQL Server tables in a query. I have to admit that I do not have many "mixed" databases, and the ones I do have tend to use just one or two views from SQL Server. If you have OTHER SQL Server tables, I would try to build queries using those tables to see how they function. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith Williamson Sent: Thursday, February 08, 2007 10:16 AM To: Access Developers discussion and problem solving 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 <http://www.rtkl.com/> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com