Audit on certain tables in a database

[mls via AccessMonster.com]

Hi,
Is it possible to keep track of all the activity on one table in an ACCESS
database ( 2000)?
I want to generate a log with username, time connected, time logoff, their
privilages RWX, activity if possible on that table

 

[Allen Browne]

Access 2010 (due out later this year) will be the first version that can do
this for you, as it supports Data Macros on the table. It's not possible to
do this automatically in Access 2000.

If all entries are performed through forms, you can use the form events to
write a log table. It takes a bit if effort, but it can be done. Here's an
explanation of how:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

The other option you have is to store the data in another database that has
a logging option (such as SQL Server), and link your Access application to
it (i.e. use attached tables.)

 

[mls via AccessMonster.com]

migration to Access 2010 will not happen in our field so how can I prevent
others from deleting tables from our database? I don't even have a list of
user who has previlages to this database.

and I don't think MDE is an option for us as it only prevent FORM, Reports
and code and not tables and queries.

Thanks

 

[John W. Vinson]

migration to Access 2010 will not happen in our field so how can I prevent
others from deleting tables from our database? I don't even have a list of
user who has previlages to this database.

Can you get agreement from management that users who destroy company assets by
deleting tables will be sternly disciplined, or perhaps fired? and that
employees will be told of this policy?

It sounds like some user training and discipline would be the best solution...
that, and of course good and frequent backups!

 

[Paul Shapiro]

Can you get agreement from management that users who destroy company
assets by
deleting tables will be sternly disciplined, or perhaps fired? and that
employees will be told of this policy?

It sounds like some user training and discipline would be the best
solution...
that, and of course good and frequent backups!

If you really want more granular security than Access offers, you could
switch your backend to SQL Server where permissions are more easily
controlled.