Access Security

[MKH2001]

Am looking for a guid to using Access security.

I have a database that I am to share on the network and want to secure it based on personal logons.

I want to be able to assign individual rights to each user and also a way of tracking what changes etc have been made who has run what etc?

Anyone know of any guides to this? couldnt find anything related when searching the forums.

 

[JerryKlmns]

LIDIAS13

You could start from the microsoft site or elsewhere but keep in mind to create groups and assign rights to groups and add users to groups. Do avoid assigning rights directly to users even if it takes you to create an one-user group!
About tracking on changes or actions taken (viewing also?) by users, there is nothing easy or build-in you could use. It is gonna be your effort (consider help from tek-tipers as granted) to create tables for keeping transaction records....

(BTW is Lidias a panatha?)

 

[Bob44TheCat]

lidias13,

Also, have a read of this:

http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf

and this:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

Hope this helps,

Bob.