Database Usage Tracking

P

patientgrow

Quick question: I build database's for many areas in my company and I would
like to track how often they are being used if at all. Is there some way I
can track if a database is being used?
 
J

Jeff Boyce

One approach I've used is to add a "UseLog" routine to each front-end I
deploy to a user's desktop/PC. I use a common back-end table to hold the
records, regardless of the application's back-end.

In my routine, I have the front-end write once to create a new record when
the application is launched, and then update that record w/ enddate/time
when the app is closed.

I use the common UseLog records to generate a monthly "usage stats" report.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I

IRS Intern

you need to use a real database like SQL Server

This will allow you to run SQL Profiler-- which is a simple tool that
allows you to SEE and STORE 'what is happening in the database'

Accesss MDB is obsolete because it doesn't have this functionality
 
Top