Security levels in a database

[Fred's]

Hi folks,

I have a form in my access database, with a loging "username" and
"password" which I will like to share with other departments. Can
somebody tell me how can I make the following security levels in my
database.

1. I will like to create an "ADMINISTRATOR" (This person can add,
edit, copy, view ect...)
2. I will like to create "USERS" (These users must have only "view"
rights onl)

Your help will be much appreciated

Thank you to all,
Fred's

PS: you can post your respponses to this group and/or to my personel
email: (e-mail address removed)

 

[John W. Vinson]

Hi folks,

I have a form in my access database, with a loging "username" and
"password" which I will like to share with other departments. Can
somebody tell me how can I make the following security levels in my
database.

1. I will like to create an "ADMINISTRATOR" (This person can add,
edit, copy, view ect...)
2. I will like to create "USERS" (These users must have only "view"
rights onl)

Your help will be much appreciated

Thank you to all,
Fred's

PS: you can post your respponses to this group and/or to my personel
email: (e-mail address removed)

Do you REALLY REALLY want to reinvent the wheel... or perhaps I should
say reinvent the internal combustion engine?

Access' security model does exactly this. It's not trivial to
implement, but it's one heck of a lot easier - and much more secure -
than creating a "roll your own" security model!

Check out the Access Security Whitepaper:

Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Study it *carefully* - as I say, it's not trivial; but if you follow
the instructions carefully it will do what you want, for much less
effort than programming your own variant.

John W. Vinson [MVP]