Newbie: How to give permissions

[Quique79]

Hi!

I'm an Access newbie, I want to restrict the access to some users, dependign their arear, they could enter in some areas like orders, products, etc and others to invoices, reports, etc

Any hint, tip or any web site where I can find something related?????

thanks Quique79

 

[dumdum]

Access security is a huge issue. You'll prob get a bigger response in a security forum.


Start reading almost anything you can find on security (for access that is). You'll need to learn about setting different levels of security and assigning those permissons to individual users, or groups of users. I have no idea what I'm talking about

 

[Garridon]

You can use MS Access' security permissions (run the help to get more information). Users can be assigned to groups, which then can be restricted to using certain forms and reports (bear in mind, you have to make sure you give them access to the underlying query and tables as well).

If you want to experiment with it, create a test database and assign permissions to that. Go to the menu bar: TOOLS>SECURITY>USER LEVEL SECURITY WIZARD. As you go through the steps, you'll come to one that asks you if you want to make this your default workgroup or if you want to create a shortcut. Choose the shortcut option. If you choose the default option, it will affect all your databases, not the one (please note the help on security will NOT tell you this). Go through all the steps, including adding users.

On the menu bar, user permissions allows you to assign a group to a specific form, report, query, table--and give them some kinds of permissions (like being able to edit a record). User and Group Accounts allows you to move people from account to account. But if you need to add a person later on, you need to rerun the wizard. It'll generate a new snapshot file--make sure you save it! It doesn't include anything you did previously, only the changes.



Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com

 

[etrain]

I have used Access's security on a very limited basis and as "dumdum" (nice name by the way ) it is a huge issue. I don't like it specifically because of the WorkGroup File everyone has to be joined to before the security will work. Then once they are joined to this work group it affects all their Access databases. For a dB that is not secured it may not restrict them from doing anything but they have to log on.

I have created my own less huge security. I use a User Table, a Workgroup Table, a security checking function, and a Form that stores the user information while they are logged on. I have not gone live with this but in test and development it works as intended. It may not be as easy as the Security wizards that are delivered with access but it works for me. More things are in the VBA code and not tables so down the road it may be harder to maintain as well but for now it works.

Not sure what was meant by this reply. Just was giving my two cents.
Remember the Past, Plan for the Future, yet Live in the Now for tomorrow may never come.
-etrain