Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language:
Expertise: Beginner
Aug 6, 1997

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.

 

 

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