log files and access to certain data based on user

F

FL Consultant

I have two questions.

1) How do you create a log file that will capture changes that a user makes
to the data base so you can determine which user modified a file?

2) How do you limit a user from making changes to certain fields but still
view the all fields? So a master user would have all access while a sales
rep may only be able to modify certain data.

A good book that covers this kind of information or location of info like
this would be great.

Thanks
 
D

Douglas J. Steele

For your first question, take a look at what Allen Browne has at
http://www.allenbrowne.com/AppAudit.html

For your second question, how secure does it need to be? If you do your
updates through a form, you can limit what a user can update. However, if
they know Access, they can go around the form and update the tables
directly. If that's a concern, you'll need to look into Access Security, so
that they can't update the tables directly. To learn more about Access
Security, check out the Access Security FAQ at
http://support.microsoft.com/support/access/content/secfaq.asp
 
Top