Dan Waters
dwaters at usinternet.com
Mon Jan 23 15:05:57 CST 2006
Doris, 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 users? 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. Thanks! Dan -----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 John, 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 http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com