ADO Connection

  • Thread starter Thread starter Weste
  • Start date Start date
W

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.
 
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
 
Back
Top