Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / June 2005

Tip: Looking for answers? Try searching our database.

Deleting persistent connection.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Diane - 24 Jun 2005 03:51 GMT
For network performance reasons, I maintain a persistent connection to my
back-ends (on the network) from the front end (locally) - actually a tip I
learned from this community.

I'd like to be able to automatically log users off, and I'm not sure how to
get around the persistent connection issue.

Any help would be greatly appreciated.
Nikos Yannacopoulos - 24 Jun 2005 10:55 GMT
Diane,

Use a single field, singel record table in the back end; value is
usually False, you set to True when you want to kick everyone out;
A timer event in an (open at all times) form in the front end, checks
the value periodically; if the value is True, give the user a warning
message and close the front end.

HTH,
Nikos

> For network performance reasons, I maintain a persistent connection to my
> back-ends (on the network) from the front end (locally) - actually a tip I
[quoted text clipped - 4 lines]
>
> Any help would be greatly appreciated.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.