sgoodhall at comcast.net
sgoodhall at comcast.net
Thu Feb 8 10:15:07 CST 2007
I don't know about the limits on the number of tables, but I can't believe it would be that low. I have run into limits on the number of fields in a query. Nominally this is 255, but some non-obvious things get counted. My personal practice is to put all query logic over into SQL Server Views or Stored Procedures, so I don't run up against this that often. My Client Application retrieves and updates against the Views or invokes Stored Procedures for complex updates. If you define your Access application as an ADP as opposed to an MDB, you can do most of the editing in SQL from the Access Development Environment. Regards, Steve Goodhall, PMP -------------- Original message ---------------------- From: "Keith Williamson" <Kwilliamson at RTKL.com> > 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