Database Logging
-
Hi All, I have a project where I am trying to become familiar with a database app. I'd like to log the queries made against the database (an access database accessed through ADO). What's a good utility for logging database activity?
-
Hi All, I have a project where I am trying to become familiar with a database app. I'd like to log the queries made against the database (an access database accessed through ADO). What's a good utility for logging database activity?
If I were tackling this I would try this. With Access you can use VBA in a Trigger. (I'm not an access guru, but I know it's possible.) Create the trigger to occur on selection Create a FileSystemObject (Scripting.FileSystemObject) in the trigger. Open a text file using the FileSystemObject.TextStream Write the contents of the query to the the text file. I'm not sure if you can pull the actual query string so you'll need to check. I'm also not sure if this will work, but it's a good place to start. Torin Blair
'In the immortal words of Socrates - "I drank what?".'