[dba-SQLServer] Upsize wizard and named queries

Mike & Doris Manning mikedorism at verizon.net
Sat Jan 21 10:11:44 CST 2006


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






More information about the dba-SQLServer mailing list