EMERGENCY HELP!!! Tracking any reports opened

[MaxEd]

Here's my problem, I have a user who has table level access and knows enough about ms access to create a laundry list of problems. Restricting access to the tables level isn't an option. The user has over 200+ reports and I need to know which reports the user is using or any other users using the database.

Here are my options:

1.) Go into each report and add code to do a dump of the report they use on the OPEN event. (take way too much time)

2.) Have code running in background to catch it each time any report is opened.

Thanks.

-Laughter works miracles.

 

[PaulBricker]

Well, you can test to see if a specific report is open using the SysCmd method.

SysCmd(acSysCmdGetObjectState, acReport, "ReportName")

You would probably have to use it in a Conditional Statement inside a Loop to
1. Test to see if a report is open and
2. Do whatever you need to at that point.

It might be a place to start.

Paul

 

[PHV]

A starting point:
For Each rpt In CurrentProject.AllReports
Debug.Print rpt.Name, rpt.IsLoaded
Next

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[MaxEd]

PHV,

Where would I put that code so that it will remain running while they are working in Access? They don't have any forms open at all. They work at the table level and open reports through the database menu.

-Laughter works miracles.