Securing Data

[Guest]

We have a shared Access 2003 database with no user login, approximately 30
users, and there are many users active in tha database at any one time. We
use a front end, back-end design, for our customer records.

I have 2 questions.

Is it possible to make the comments written buy a user un-editable once you
leave that record? Comments are a subform of the customer record form and
comments reside in their table.

Second question.

Is it possible to record who makes changes to any record/customer info?

 

[Guest]

1. You'll need to implement user level security to attempt this.

2. It isn't too hard to track who originally created a record and when. You
can also track who last edited a record and when. Tracking ALL changes
becomes difficult. Also tracking record edits only works when using a form so
if some can get directly at the tables or create a query, then all bets are
off. You would again need user level security to make this happen.

You can find code to track ALL changes at:
http://www.mvps.org/access/modules/mdl0021.htm

If you just want to track who created a record and made the last change,
this is a good place to start:
http://www.mvps.org/access/api/api0008.htm