Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Expertise: Beginner
Aug 6, 1997



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Logging User Activity with VB and Access

A while back, I wrote a simple orders application that allowed users to query and update order information. The application worked fine, but lacked a user activity log. It was difficult for me to determine what a user had done with a particular order.

By creating a table (I'll call it UserLog) with fields such as DATE, TIME, USERID, ACTION _TYPE (A for accepted entry or Q for queried database), SQLSTRING (for the actual SQL command issued against the database), and other data element fields, I was able to capture user activity at key points in the application. The AddItem method allowed me to quickly add records to the UserLog table when the user queried the database or when the user accepted data.

Not only is the user log concept useful for tracking user activity, it's also useful for analyzing trends in data such as who is updating the data, how often, and what type of queries are being performed on the database.

Brian Prebola
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date