Keith Williamson
Kwilliamson at RTKL.com
Thu Feb 8 10:35:28 CST 2007
Well....MIS tells me there is nothing wrong with the table. This is just counter-intuitive. IF I run the query without the select from (to that linked table)...it runs great. IF I download the data from the linked table, to a local Access table....it runs great. BUT...if I run the query, with the select from the linked table....crash. I only have 4 joined tables (2 local and 2 linked), and the select statement from the linked table. I only have about 40 fields in the entire query. Based on the above, it doesn't appear to be anything wrong with the data (since the downloaded data worked fine.) Maybe I'll try re-linking the table. Can a link get corrupted? 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 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of artful at rogers.com Sent: Thursday, February 08, 2007 11:13 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Linked Table Limits? 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com