Forms security

[danikuper]

Hi!

I've been trying this now for some time and am getting frustrated. Any help is greatly appreciated

I have a database with several forms and I'd like to limit access to the forms based on the user that logs in. For example, I want to set the following security:

User: Sales
Opens only: Sales form
User: Accounting
Opens only: Accounting form

I tried using access user level security wizard and created all usernames, groups and restrictions however it does not seem to work. Although the user is prompted for a passwd when opening the database, he can open any form - not only the one I gave him access to!

I must be doing something wrong or this feature (MS Access 2000) is buggy.

Does someone know how to solve this?

Thanks again!

 

[Autoeng]

Access Security isn't very buggy but it is very particular. Everything has to be right for it to work correctly.

It sounds as if you are using the shortcut that Security created for you to enter your db, is that correct? You must use this shortcut in order for the correct workgroup settings to be applied.

If you are using the shortcut please try and detail what you have done as far as setting up the security and I'll try and help you out.

Autoeng

 

[IMO]

This Link may help you with your forms.

http://users.bigpond.net.au/abrowne1/ser-15.html


IMO

 

[danikuper]

Shortcut? Humm... I haven't noticed any shortcuts on my desktop created by access. Maybe that's the problem.

Anyways, what I tried to do is the following:
1. I went to User and Groups Accounts and created my users
2. Then I went to the User and Group permissions and selected for each user a different form, giving them open/run access and not giving them any access for other forms they weren't supposed to open
3. I ran the security-level wizard

When opening a database, access asks for a login ID and for those users that I gave only open/run permission, they can open the forms and not modify it (which is fine) however they can still open forms I didn't give permission to.

Another thing I noticed is that when I tried to create a new database, access would ask me for a loginID before saving it... could it be a problem with my secured.mdw?

thanks!!!

 

[Autoeng]

After a db is secured you must enter it through a shortcut which does 3 things...

- Starts Access

- Opens the appropriate db

- Joins the appropriate workgroup

The shortcut target is like this.

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" "directory location\database.mdb" /wrkgrp "directory location\secured.mdw"

It sounds like the first thing you need to do is read the Microsoft Security Faq located here...

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

Read it several times. Applying security is not just something that you jump into as there are many things to be considered.

Autoeng

 

[danikuper]

I'll take a look at the FAQ. Thanks a lot!