By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,872 Members | 2,333 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,872 IT Pros & Developers. It's quick & easy.

MS Access - Creating an audit trail

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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, rh******@yahoo.com (Sarah) wrote:
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


Nov 12 '05 #2

P: n/a
Thanks, that was a great paper. Much better than the books I had.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.