Keith Williamson
Kwilliamson at RTKL.com
Thu Feb 8 10:04:52 CST 2007
I suspect there must be a corrupted record in that particular table. I know I have run queries before with just as many, if not more, joined tables (that are linked to sql database.) I was hoping someone had some quick info about such a situation. But alas, I have to dump the issue on our MIS laps, to investigate the offending table. 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 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Thursday, February 08, 2007 10:29 AM To: 'Access Developers discussion and problem solving' 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