L
listrecv
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)! (Audit Login, Audit
Logout).
How can I tell Access to keep the connection persistent, and not keep
on hanging up and reconnecting?
What's bizzare is that this behavior only happens for forms - not when
I just open the table in access normally.
(PS - If this post is unclear, or you need more information, please let
me know!)
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)! (Audit Login, Audit
Logout).
How can I tell Access to keep the connection persistent, and not keep
on hanging up and reconnecting?
What's bizzare is that this behavior only happens for forms - not when
I just open the table in access normally.
(PS - If this post is unclear, or you need more information, please let
me know!)