 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Developer Toolkits / July 2006Calling 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. >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. 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  SignatureTony 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 > 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. 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. > 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. 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. You can put code in the timer_event of a (hidden) form to check what tables /queries are loaded HTH Pieter >> No, there is nothing similar for queries or tables. However if you >> restrict the users from viewing tables or queries then that should be [quoted text clipped - 6 lines] > AccessObj.AllQueries and check for AllQuiries.Isloaded = true. Still > don't have an event to put it in though. Signature---------------------------------------- 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 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.