Access, SQL Server, and bound controls

[CylonLove4Life]

I have an Access DB using bound controls to linked tables on a SQL Server.

The SQL Server profiler shows that Access is consistently logging in and logging out, each time a form is loaded, or a control changes (and a corresponding control needs to be refereshed)!

How can I tell Access to keep the connection persistent, and not keep on hanging up and reconnecting?

 

[danvlas]

Try keeping a bound form open at all times (in hidden mode)?

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[CylonLove4Life]

Yeah, I tried it, doesn't work. I think that trick is only for MDB back ends, not SQL Server back ends.