open & close time of database?

[Shivalee Gupta via AccessMonster.com]

i am working on access 2000. can i write a code which will tell me, at the
time of closing the database, that at what time i had opened the database
and at what time i am closing it? i am in a single user environment. i just
want to check whether someone is opening my databse behind my back!
thanks.

--
Message posted via http://www.accessmonster.com

[pietlinden]

Shivalee Gupta via AccessMonster.com wrote:

i am working on access 2000. can i write a code which will tell me, at the time of closing the database, that at what time i had opened the database and at what time i am closing it? i am in a single user environment. i just want to check whether someone is opening my databse behind my back!
thanks.

--
Message posted via http://www.accessmonster.com

use a hidden form.
open it at startup.
in the open event of the form, write the user's NT logon name and the
time (datestamp) to a table. and then maybe a T/F for open/close
(True=Open)
Then in the unload event of the form, do the same, just use False.

And if you can't figure that out, you really do need a clue.

[Shivalee Gupta via AccessMonster.com]

i do need a clue. i didnt understand a word of what you have written.
actually i am a very new learner. could you be kind and explian how to go
about doing it?
thanks a zillion.

--
Message posted via http://www.accessmonster.com

[MacDermott]

Another way of saying what Piet means:
This is not a built-in function in Access which you can simply activate.
If you don't know enough Access to follow his instructions (which really are
pretty simple for anyone with knowledge of Access coding), you should look
for some Access training before attempting this task.

OTOH, if you can make sure that Outlook is always on, you can use its
Journaling option to record when your database is opened. You can find
basic instructions on Journaling in the Outlook help file; if you need
further help, you could post in an Outlook group.

"Shivalee Gupta via AccessMonster.com" <fo***@AccessMonster.com> wrote in
message news:77******************************@AccessMonste r.com...

i do need a clue. i didnt understand a word of what you have written.
actually i am a very new learner. could you be kind and explian how to go
about doing it?
thanks a zillion.

--
Message posted via http://www.accessmonster.com

[Tim Marshall]

pi********@hotmail.com wrote:

And if you can't figure that out, you really do need a clue.

? What did the OP do to deserve that? Have I missed other threads?

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Shivalee Gupta via AccessMonster.com]

is it a punishment to be a newcomer? is it bad to be a learner? is it not
an open forum where in and through which i can learn? or do all & everyone
go through only a course or something to learn?
still, thnaks for your time,
shivalee.

--
Message posted via http://www.accessmonster.com

[dkintheuk]

Got to agree with you both... no need to be nasty to someone just
becuase they are learning.

In fact this is not a simple task and it would be advisable to get some
other advice first, but there are better ways of explaining things that
might have been more easily understood.

Shivalee, you should begin by getting advice on how to write code
modules in Access Visual Basic. This is best received from several
books you can search for on Amazon or similar book sites. You can also
search for web sites offering free tutorials.

Then once you understand how to create new code and to refer to it in
relation to other elements of your database, you can develop a function
as described in the original reply to your message. In essence whatthe
poster was saying is that you have to create a form that is not
attached to a table and add a code module to it that is triggered by
the form being opened.

That code will just refer to a table in your database that you should
have created already to allow the entry of the username and date/time
stamp.

Then you add further code to the form so that when it is unloaded
(similar to closed) the username and date/time are written to the table
again.

The true/false bit says that you should also write a value to the table
to tell whether it is refering to an open or close event.

If you are still stuck by that then i suggest reading up a little on
the subject first and trying some simple examples from other places.
Then come back to this.

Regards,

Rob.

[Shivalee Gupta via AccessMonster.com]

thanks rob for at least being supportive. i shall try and do as you say.
thanks,
shivalee

--
Message posted via http://www.accessmonster.com