Password Security & audit Trail

[kedarj]

Hi All,
i need some more help.
I have an access application which has 6 different forms. The application will be accessed by 10-12 people. some can have an access to to all the forms and some may have an access to a few of them. How can I set up the password security for the users at application and form level?
I also want to capture the audit trail when the user users edit form and makes changes to a record.
I would apprecaite help on this one.
Regards
K

 

[ghudson]

Use Access security to define the workgroups and the users permissions. Search around for there are tons of threads on how to implement Access security into your db. Ensure you understand it before you attempt to secure your db. Make copies of your db before, during and after the process for you could lock your self out.

This Audit Trail sample is a popular thread on this forum.