 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / May 2005Throwing Users Out
I have a split database (several, actually, but one will do as an example): back end on a server, front end on each user's computer. Back end gets refreshed each Monday between 6 and 8, and the front end has a built-in warning message that " database is not available before 8:00 on Mondays," then shuts down the database. However, there's at least one smart-a** who knows enough Access to bypass that message and signs onto the database before 8:00. That prevents me from doing the refresh for the other 200-odd users. Does anybody know a way that as the database owner I can go in and throw anybody and everybody out of the database when I need sole access? At one time I thought asking nicely would suffice, but obviously I'm going to have to be a pr*** to keep reasonable control over the situation on Monday mornings. There are lots of ways. I have code in a hidden form that runs every 3 or 4 minutes. It looks at the value of a table (which nly has one field and one record) and if that value is a "1" then nothing happens. If it is a "2" then a pop-up warns the users that the database will close for maintenace in 5 minutes. If it is a "3" then it does the command "quit". My startup macro checks the value of that table and does not let the database open if it is a 2 or 3. Do a search. There is a procduct I have seen mentioned that is called "kick 'em off". Go to google groups and search for... microsoft.public.access kick off users  SignatureRick B > I have a split database (several, actually, but one will do as an example): > back end on a server, front end on each user's computer. [quoted text clipped - 12 lines] > to be a pr*** to keep reasonable control over the situation on Monday > mornings. Cool -- I'll try it. > There are lots of ways. I have code in a hidden form that runs every 3 or 4 > minutes. It looks at the value of a table (which nly has one field and one [quoted text clipped - 30 lines] > > to be a pr*** to keep reasonable control over the situation on Monday > > mornings. |
Reply to this Message |
 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.