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. 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. 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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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 ;...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
|
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...
|
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...
| |