[dba-SQLServer] Access Connection to SQL Server (was: Upsize wizard and named queries)

Dan Waters dwaters at usinternet.com
Mon Jan 23 15:05:57 CST 2006


Can you give more information on this?  Which versions of Access and SQL
Server are you using.  You said this limits the connection string packet
size, but what impact does that have on the developer?  Or impact on the

Are you using CurrentProject.Connection or CurrentProject.AccessConnection?

I am about to begin developing a system using Access 2003 as the FE and SQL
Server 2005 as the BE, and would like to know more about this issue.


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mike &
Doris Manning
Sent: Saturday, January 21, 2006 10:12 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Upsize wizard and named queries


The biggest problem with connecting to SQL Server through Access is that
Access automatically limits the connection string packet size to 4096.  I
have yet to find any way to change that within Access.  This is one reason
why I've been slowly moving all my company's apps over to VB.Net.  There, I
can control the connection by changing the packet size to 32767 which is as
wide as it can go.

Doris Manning
mikedorism at verizon.net

dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list