473,320 Members | 1,612 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Log Access User Activity?

Me
Hi, I have an interesting need:

after merging dozens of databases on a large company IT environment,
we would like to know, over time, which objects of the 3 MDBs left are
most often used by users, we suspect 80% of them aren't used.
Some users use forms, but some click directly on macros or
tables/queries.
is it possible to implement an activity logging mechanism in access,
which would record in a table an entry for every time the user opens
up an access object? the forms/reports/macros are easy, just add a
small update query at their beginning to log when they are open. But
what about queries/tables?

also, there are hundreds of objects! to go through each and every one
of them
and add the logging command, would be a task well circumvented....
is there some API or property of the Access application (we use ver.
2000) that
can help with this?
I thought of having the SysCmd(acSysCmdGetObjectState, objtype,
objname)
command run from a startup form in the background, on a timer event,
in an endless loop on all objects in the mdb every couple of seconds
and update the log table if their status is active, but that seems...
a little too much overhead, as well as not 100% certain to catch all
activations.
any ideas?

thanks

hh.
Nov 13 '05 #1
2 7211
As there are no events associated with viewing tables or queries, or
executing macros, the answer is "no, you can't do what you want". There is
no builtin logging feature.

In a developed application, it is possible to record use of Forms and
Reports, and that is all that you normally would allow, and the code to do
that can be added programmatically. But, it clearly will not satisfy your
requirements.

Larry Linson
Microsoft Access MVP
"Me" <he****@lycos.com> wrote in message
news:2d**************************@posting.google.c om...
Hi, I have an interesting need:

after merging dozens of databases on a large company IT environment,
we would like to know, over time, which objects of the 3 MDBs left are
most often used by users, we suspect 80% of them aren't used.
Some users use forms, but some click directly on macros or
tables/queries.
is it possible to implement an activity logging mechanism in access,
which would record in a table an entry for every time the user opens
up an access object? the forms/reports/macros are easy, just add a
small update query at their beginning to log when they are open. But
what about queries/tables?

also, there are hundreds of objects! to go through each and every one
of them
and add the logging command, would be a task well circumvented....
is there some API or property of the Access application (we use ver.
2000) that
can help with this?
I thought of having the SysCmd(acSysCmdGetObjectState, objtype,
objname)
command run from a startup form in the background, on a timer event,
in an endless loop on all objects in the mdb every couple of seconds
and update the log table if their status is active, but that seems...
a little too much overhead, as well as not 100% certain to catch all
activations.
any ideas?

thanks

hh.

Nov 13 '05 #2
he****@lycos.com (Me) wrote in message news:<2d**************************@posting.google. com>...
Hi, I have an interesting need:

after merging dozens of databases on a large company IT environment,
we would like to know, over time, which objects of the 3 MDBs left are
most often used by users, we suspect 80% of them aren't used.
Some users use forms, but some click directly on macros or
tables/queries.
is it possible to implement an activity logging mechanism in access,
which would record in a table an entry for every time the user opens
up an access object? the forms/reports/macros are easy, just add a
small update query at their beginning to log when they are open. But
what about queries/tables?

also, there are hundreds of objects! to go through each and every one
of them
and add the logging command, would be a task well circumvented....
is there some API or property of the Access application (we use ver.
2000) that
can help with this?
I thought of having the SysCmd(acSysCmdGetObjectState, objtype,
objname)
command run from a startup form in the background, on a timer event,
in an endless loop on all objects in the mdb every couple of seconds
and update the log table if their status is active, but that seems...
a little too much overhead, as well as not 100% certain to catch all
activations.


In addition to what Larry said, you could hide the database window and
use the form from the Developer's Handbook and then since you'd be
driving everything from a form, you could grab the code from Allen
Browne's website and use that to do the logging. Won't be super
simple because you have so many forms etc, but that's about the only
option.
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Frnak McKenney | last post by:
Back when computer dinosaurs roamed the earth and the precursors to today's Internet were tiny flocks of TDMs living symbiotically with the silicon giants, tracking access to data processing...
4
by: Kenneth Courville | last post by:
Hello, I have an application that will be logging to a SQL Server 2000 database user user activity from several Windows 2003 terminal servers. This information will be retrieved by monitoring...
1
by: Dennis Freud | last post by:
Hi all, I wish to realise a project where the main user interface consists of a spreadsheet like display. This has a scrollbar at the bottom and if neccessary one on the side as well. The x.axis...
9
by: J Bunton | last post by:
My Access 97 applictions seem to have recently become very Cpu useage hungry. When opened they go to almost 100% useage on the peformance monitor. After several seconds this returns to near...
11
by: Will | last post by:
I am looking at using a table with user names, passwords and user rights, which I would administer. I have read a lot about the shortfalls of this and the lack of security but the customer does...
14
by: alwayshouston | last post by:
Hi All! I am working on this very small database and I am confused in the designing a simple form. I only have three tables in the database. First Table: tblExpense Columns: ExpenseID ;...
22
by: alecjames1 | last post by:
I have a form which the user must complete before closing. I have disabled the window x button and use my own exit button. When selected it checks to see if the user has completed the entries...
1
by: LostBoy | last post by:
Hello, I have been giving a big task to add some additional features to the Access DB at work. I am not the one who originally created the DB, which makes it harder. I am familiar with access but...
10
by: Les Desser | last post by:
In article <fcebdacd-2bd8-4d07-93a8-8b69d3452f3e@s50g2000hsb.googlegroups.com>, The Frog <Mr.Frog.to.you@googlemail.comMon, 14 Apr 2008 00:45:10 writes Thank you for that. It was very...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.