[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