[AccessD] Linked Table Limits?

JWColby jwcolby at colbyconsulting.com
Thu Feb 8 10:14:22 CST 2007


You may be right.  Memo fields are a corruption issue in Access and if there
were fields in SQL Server being treated as memos in Access, it could cause
problems. 


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 11:05 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Linked Table Limits?

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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list