ADO Connection

[Weste]

We have an Access 2003 application with linked tables to SQL Server. We have
alot of VBA code. Is it better to open a connection to SQL server and use
that same connection for all the applicabble procedures or open and close the
connection for each procedure? Thanks.

 

[Klatuu]

A presistent connection wil give better performance.

 

[Alex Dybenko]

Hi,
As Dave mentioned - persistent connection will give better performance, but
it also consume resources. So I suggest to make some tests in you
environment, sometimes its more efficient to open/close connection each time
you need it then to have a persistent one.

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com