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