Previous Thread:   Packaging Wizard "Error In Loading Dll"

6/14/2006 9:08:27 AM    Calling a log function with tables and queries?
I have a log function that I have embedded in the onOpen event of all  
  
reports and forms.  I was  
  
wondering if there is an Access Namespace that keeps track of open  
  
queries and or table names or lets me access those events so I can call  
  
the function for tables and queries as well.  I have the data that I am  
  
recording exported to SQL Server via ADODB in VBA.  If anyone knows how  
  
to access those things, or if there is a better way to log all actions  
  
done by a standard user in access please let me know.



6/14/2006 12:41:09 PM    Re: Calling a log function with tables and queries?
Its not that I don't want them to get to the queries or tables.  I just  
  
want to know exactly which tables and queries are being accessed.  
  
Thanks for the reply.  I have been researching this pretty hard all  
  
morning and the closest thing I have found, would be to use an  
  
AccessObj.AllQueries and check for AllQuiries.Isloaded = true.  Still  
  
don't have an event to put it in though.

6/14/2006 12:45:49 PM    Re: Calling a log function with tables and queries?
"NathanJ" <NathanielAJohnson@gmail.com> wrote:  
  
No, there is nothing similar for queries or tables.   However if you  
  
restrict the users from viewing tables or queries then that should be  
  
sufficient.  
  
Tony  
  
--  
  
Tony Toews, Microsoft Access MVP  
  
Please respond only in the newsgroups so that others can  
  
read the entire thread of messages.  
  
Microsoft Access Links, Hints, Tips & Accounting Systems at  
  
http://www.granite.ab.ca/accsmstr.htm

6/14/2006 12:54:31 PM    Re: Calling a log function with tables and queries?
Its not that I don't want them to get to the queries or tables.  I just  
  
want to know exactly which tables and queries are being accessed.  
  
Thanks for the reply.  I have been researching this pretty hard all  
  
morning and the closest thing I have found, would be to use an  
  
AccessObj.AllQueries and check for AllQuiries.Isloaded = true.  Still  
  
don't have an event to put it in though.

7/19/2006 12:01:30 PM    Re: Calling a log function with tables and queries?
You can put code in the timer_event of a (hidden) form to check what tables  
  
/queries are loaded  
  
HTH  
  
Pieter  
  
"NathanJ" <NathanielAJohnson@gmail.com> wrote in message  
  
news:1150314871.542015.229630@u72g2000cwu.googlegroups.com...  
  
--  
  
----------------------------------------  
  
I am using the free version of SPAMfighter for private users.  
  
It has removed 4285 spam emails to date.  
  
Paying users do not have this message in their emails.  
  
Get the free SPAMfighter here: http://www.spamfighter.com/len

7/19/2006 4:28:48 PM    Re: Calling a log function with tables and queries?
If you restrict access to the database and use the solution from Access  
  
Developer's Handbook that essentially mocks up the Access UI, you can  
  
insert some logging code in the click events of the objects.  Then you  
  
can log who is opening what without a problem.