Re: Logging users

Lots of previous posts out there...

http://groups.google.com/groups?q=microsoft.public.access+log+users&hl=en


--
Rick B



"asset via AccessMonster.com" <u19405@uwe> wrote in message
news:5eab102d46f64@xxxxxx
sounds great.. but how exactly.... grateful if you could set me on the
road.
Any ideas on how???

regards


Rick B wrote:
There is no built in feature. You will have to build it. Most people do
so
by opening a form with the database. They open the form as "hidden" and
they tie code to it in the OPEN and CLOSE event. The OPEN event adds a
record to a table including the UserID, Date, Time, etc. The CLOSE event
can be coded to find that record and update it with a time and date
closed.

There are lots of ways to do it, but the short answer is that there is no
built-in feature for this.

I'm trying to log users who have accessed or are accessing a database
(Access
97). Does access 97 provide a utility that does it, if not can it be
done?

Thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200604/1


.

Relevant Pages

  • Re: Logging users
    ... grateful if you could set me on the road. ... Rick B wrote: ... by opening a form with the database. ...
    (microsoft.public.access.security)
  • Re: Macros with runtime
    ... was opening the db but not running the macro. ... >Rick wrote: ... >> database? ... >> command line? ...
    (microsoft.public.access.macros)
  • Re: Access 97 conversion rejection
    ... I have tried both ways of opening it, ... the database in Access 97. ... Rick ... >application first and then conversion goes well. ...
    (microsoft.public.access.conversion)
  • Re: Remove Password
    ... "Rick B" wrote: ... This assumes that he created a new workgroup before playing around ... so secure no one could get in!! ... Adding userid's and passwords to a workgroup does not secure a database ...
    (microsoft.public.access.security)
  • Re: As a generale rule - Query or VBA?
    ... I agree with you Rick, I was recently working on a database that had ... the query is saved, then JET will save the fastest execution path. ...
    (comp.databases.ms-access)