Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2003
    Location
    Toronto, Canada
    Posts
    18

    Unanswered: Log off Users in shared drive - Access2000

    I have an Access2000 app placed on a shred drive. The problem i am having is that users leave it opened and take long breaks. Sometimes they leave it overnight. I would like to make corrections to the form but can't. How can I save and close all users. I would like to send a message telling all users to save any changes and give them 1 minute before shutting down.

    Thanks

  2. #2
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by CKENTEBE
    I have an Access2000 app placed on a shred drive. The problem i am having is that users leave it opened and take long breaks. Sometimes they leave it overnight. I would like to make corrections to the form but can't. How can I save and close all users. I would like to send a message telling all users to save any changes and give them 1 minute before shutting down.

    Thanks
    Here is a site that offers software to do just what you are asking about..

    Bud
    http://www.fmsinc.com/products/Admin/index.asp

  3. #3
    Join Date
    Feb 2003
    Location
    Toronto, Canada
    Posts
    18
    Thanks but i was looking for code in VBA.

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    Quote Originally Posted by CKENTEBE
    I have an Access2000 app placed on a shred drive. The problem i am having is that users leave it opened and take long breaks. Sometimes they leave it overnight. I would like to make corrections to the form but can't. How can I save and close all users. I would like to send a message telling all users to save any changes and give them 1 minute before shutting down.

    Thanks
    i not the only one in the same boat

    i use the Time event on my My menu Screen if that was current for more than 5 min it would close the program down but when the use went differnace menu the counter would clear it seft.

    don't ask for the code that was one databases I forgot to get when i leaf the company 'bugger'
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  5. #5
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Talking

    Quote Originally Posted by CKENTEBE
    Thanks but i was looking for code in VBA.
    Sorry but don't know of anyone with the code. That program however does give great control of you managing the database. Only heard of 2 others who used it and they say it is great and powerful. I have seen other posts like yours but checked and none had solid replies either, but will search and see if I can find you VBA code also.

    hang in there,
    Bud

  6. #6
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    Quote Originally Posted by CKENTEBE
    I have an Access2000 app placed on a shred drive. The problem i am having is that users leave it opened and take long breaks. Sometimes they leave it overnight. I would like to make corrections to the form but can't. How can I save and close all users. I would like to send a message telling all users to save any changes and give them 1 minute before shutting down.

    Thanks
    Can you build a event in a Form

    there a exmple in the attachment

    What happens is a form hidden is opened in a hidden stat
    every 3000th of a sec it check to see if the 'main' form is open
    if not them it will close the program down

    enjoy
    Attached Files Attached Files
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  7. #7
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by Bud
    Sorry but don't know of anyone with the code. That program however does give great control of you managing the database. Only heard of 2 others who used it and they say it is great and powerful. I have seen other posts like yours but checked and none had solid replies either, but will search and see if I can find you VBA code also.

    hang in there,
    Bud
    I took a look at what they offer and in their docs they tell you what they do and how they did it ... It should be quite easy to mimic that ...
    Back to Access ... ADO is not the way to go for speed ...

  8. #8
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by M Owen
    I took a look at what they offer and in their docs they tell you what they do and how they did it ... It should be quite easy to mimic that ...
    Simply wonderful...marvelous. Let me know what ya come up with if anything.

    Bud

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •