Logging users

[asset via AccessMonster.com]

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

 

[Rick B]

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.

 

[asset via AccessMonster.com]

sounds great.. but how exactly.... grateful if you could set me on the road.
Any ideas on how???

regards

 

[Rick B]

Lots of previous posts out there...

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

 

[asset via AccessMonster.com]

thanks again.
will be checking them out.

Regards

Lots of previous posts out there...

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

sounds great.. but how exactly.... grateful if you could set me on the
road.

[quoted text clipped - 19 lines]