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 / Modules / DAO / VBA / September 2006

Tip: Looking for answers? Try searching our database.

Remote Database Closing.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ThunderTek - 29 Sep 2006 03:42 GMT
New problem for me here.

I sometimes have a need to have exclusive access to both front and back end
content.  

1. Is there a way that I can shoot a message (as in a timer) that will say
something to the effect "The database will need to come down in 1 minute for
routine maintenance."

2.  If anyone walks away front there PC while logged in....can I setup a way
to be able to close the databse from my PC (close all open instances of the
dB)?
Klatuu - 29 Sep 2006 17:08 GMT
You can't directly close their database, but you can, with a timer event and
a one record, one field table in the back end, cause theirs to close.

It does require either a form that says open as long as the app is running,
or a timer event it every form.  (The first is better and has some other
benefits)

Set the form's timer event to check the value of the field and take the
appropriate action, for example:

   If blnTimeExpired Then
       Docmd.Quit
   End If

> New problem for me here.
>
[quoted text clipped - 8 lines]
> to be able to close the databse from my PC (close all open instances of the
> dB)?
 
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.