Results 1 to 4 of 4
  1. #1
    christophe.dewinne is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2012
    Posts
    2

    Pop-up when database is blocked

    I have to do some changes in a Access-file where a lot of people have access to. Before I do that, I have to send a mail to everyone that I have to do some cleaning and that no-one may work in the file.
    When someone doesn't read his mail, they can do changes that are lost afterwards.


    Because of this problem, I search a way to block the database and let it know at the user by giving a pop-up when he wants to open the file. Does anyone know how to do this?

    Thanks.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    It is called "Kick 'em Off" and this link has a number of ways to do it: http://www.accessmvp.com/JConrad/acc...e/kickoff.html

  3. #3
    christophe.dewinne is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2012
    Posts
    2
    Now I can kick the users off but they still don't know that they may not restart the program for a while.
    What I search is a method to put a pop-up on screen when they try to open the database.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    I use a System table to Kick-em-off with a value in a field equal to the number of seconds before the users will shut down. I check this value when the system starts up and put up a message and quit if the value is non zero.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 20
    Last Post: 08-08-2011, 01:34 PM
  2. Replies: 3
    Last Post: 05-15-2011, 10:52 PM
  3. Replies: 1
    Last Post: 11-03-2010, 10:41 AM
  4. query being blocked by pop up box
    By normie in forum Queries
    Replies: 3
    Last Post: 07-10-2010, 04:33 PM
  5. Unsafe expressions are not blocked.
    By darksniperx in forum Access
    Replies: 8
    Last Post: 01-07-2010, 03:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums