MS Access - Creating an audit trail

[Sarah]

Hi

I have built a database that is currently being used by multiple
users. I have not added user-level security to it because I don't
understand it very well. I would like to add a audit trail table to
track important changes in the database and would like some VB code to
be able to do it. Also when I tried to set up user level security I
was getting a prompt for a password for every database I was using.
How do I only set up the security on one database?

Thanks

[Jim Allensworth]

Re: MS Access - Creating an audit trail

You really_do_need to implement User/Group security to do effectively
what you want. There is a white paper available to walk you through it
and adress the issues involve. Here is a link to it. Look for Access
Security FAQ (download)

http://www.mvps.org/access/resources/techpapers.htm

BTW, it sounds like you used System.mdw to set up security. You need
to create your own and use it to implement security with the security
wizard.

- Jim

On 6 Nov 2003 13:00:00 -0800, rhodesar@yahoo. com (Sarah) wrote:
[color=blue]
>Hi
>
>I have built a database that is currently being used by multiple
>users. I have not added user-level security to it because I don't
>understand it very well. I would like to add a audit trail table to
>track important changes in the database and would like some VB code to
>be able to do it. Also when I tried to set up user level security I
>was getting a prompt for a password for every database I was using.
>How do I only set up the security on one database?
>
>Thanks[/color]

[Sarah]

Re: MS Access - Creating an audit trail

Thanks, that was a great paper. Much better than the books I had.