Security

[wilko]

Hi guys,

I appreciate there have been a few of these threads knocking around, and ive spent a morning reading them, and going through my Access Book!

Essentially what I want to do is allow one type of user to have full access rights to the db, and anothe rtype of user to only have read only. I have created myself a login form, which prompts the user for a password, and then takes them to relevant form depenant on who they are. However it is very easy to break out of and start editing data.

Is there any simple way of adding this functionality, or does it have to be done through the dreaded workgroup thingy?

Many thanks

Ross

 

[Pat Hartman]

You've got to do it through the workgroup thingy. But before you do anything, make at least two backups, print out the security FAQ and read it. Then follow the FAQ EXACTLY. It is very easy to lock yourself totally out of the database or even worse (assuming you've made a backup) is that the database may not be secure at all because you've left the admin user account.

 

[L'apprentis]

Sorry to be annoying but is the "security Faq" still Exists?

 

[Pat Hartman]

If it is not here you will be able to find it in the Microsoft knowledgebase.

http://support.microsoft.com/default.aspx?scid=fh;[ln];kbhowto

 

[L'apprentis]

Thanks Pat, that's brilliant