User permissions

[kplatt]

Helllo, I would like to know how to make a database so that any individual can go into the database and enter information into a form, but they would not have access to the internal workings of the forms, tables, queries and reports that I have built. I guess i could have a password that would allow "me" the administrator to have access to these areas.

Thanks

Kevin

 

[statsman]

You did not tell us which version of Access you are using. I have not yet entered the A2007 security functions, but I can offer some advise if you are using Access2003 or earlier.

There are two separate password functions. The first is the DATABASE PASSWORD. This allows users to enter the database after entering the password. The password would be the same for all users and you can't limit what they can see or restrict the ability to make changes.

The second is the SECURITY WIZARD. With this each user has their own password and they are limited in what they can do once they log on. You set each user's permission. For a complete guide to the Security Wizard and Access Security in general go to:

http://www.geocities.com/jacksonmacd
download the first file – Security Paper by Jack Macdonald. It’s a little long but it tells you everything you need to know.

DO NOT ATTEMPT TO USE THE SECURITY WIZARD UNTIL YOU HAVE READ THIS PAPER.
Always make your first attempt at Security with a copy of your database. You will probably make any number of errors on your first try. It's a lot easier to just delete the copy and start again on another copy than trying to correct the errors.

Good Luck.

 

[kplatt]

Thanks, I am using 2007. But since you answered I was wondering if you could help me with another issue

I have a report that i use the following equation with.

=IIf([Sum Of Sum Of Pound Conversion]>=10000,"Hazardous Substance > 10,000 lbs","")

If the value exceed 10000 i want the specific cell to read "hazardous substance > 10000". But i also want the cell to be highlighed in yellow when the phrase appears and not just all the time. Any ideas? for example can I add an "and" and color code to the expression? Thanks

Kevin