Re: Self closing DB

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "LogUsersOffNonUse.mdb" which logs a user off after a period
of non-use. This could be modified to work with a specific time period as
well.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


"Luis" <Luis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6DA5458C-94B3-403B-B8B5-ADE7E0E27768@xxxxxxxxxxxxxxxx
Thank you all for the quick solution.
On my company there are lots of users that dont close the applications
when
they go home. Unfortunatelly for me and some more application developers
that
need to update some data at night and sometimes some users let the
databases
opened exclusivelly.
This is my day to day struggle and i hope i win some day.

Thanks

"Baz" wrote:

You would need to base this on a form's timer event. If you have some
kind
of splash or background form that stays open throughout, you could use
this.
Alternatively, you could have a hidden form which opens on startup and
remains open.

You could have the timer event check the time every minute or whatever
or,
if you wanted to be clever and save precious CPU cycles, when the
abovementioned form opens you could have it check the time and calculate
the
timer interval so that it only fires once, at the appropriate time to say
goodnight.


"Luis" <Luis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:74B02B15-F0A5-4407-B172-759EE7331F0F@xxxxxxxxxxxxxxxx
Hello.
I have a database that i need to close after working hours.
The idea i'm thinking is to create a process that checks the hour and
if
its
between 11pm and 12pm the database closes.

How can i do something like that?

Thanks

Luis





.

Relevant Pages

  • Re: Runtime Error Paste Method of Worksheet class failed
    ... > Private Sub CommandButton1_Click ... > Dim rngToPaste As Range ... > 'opens access ... > ' exports data from the active worksheet to a table in an Access database ...
    (microsoft.public.excel.programming)
  • Re: Runtime Error Paste Method of Worksheet class failed
    ... >> Private Sub CommandButton1_Click ... >> Dim rngToPaste As Range ... >> 'opens access ... >> ' exports data from the active worksheet to a table in an Access database ...
    (microsoft.public.excel.programming)
  • VB, ADO,Access 2000 and Record order
    ... I have a simple VB project with a function: It opens a connection to ... access database and perform an INSERT sql query. ... the second and a series of autonumber numbers! ...
    (microsoft.public.vb.general.discussion)
  • Re: Pass the form name to a dialogue
    ... is a small Access database ... So that I can use this dialogue with various forms, ... here's the code that opens the dialogue box. ... Dim stDocName As String ...
    (microsoft.public.access.formscoding)
  • RE: Office Web Components Installer
    ... to install necessary components. ... The company i work for has an access database that they somehow turned into ... If i open it on my machine, it opens fine. ... Domain Admin, Domain User with Local Admin rights, and domain user. ...
    (microsoft.public.office.misc)