One Password For Read Only, Another Password For Full-access

[svcghost]

Hey guys,

Can anyone please tell me if this is possible? We currently have a password set that prompts when you open the access database (full access rights). Can we create another password that users can use for read-only access? If not, what's the best solution to do this?

Thank you

(MS Access 2007)

 

[MSAccessRookie]

Hey guys,

Can anyone please tell me if this is possible? We currently have a password set that prompts when you open the access database (full access rights). Can we create another password that users can use for read-only access? If not, what's the best solution to do this?

Thank you

(MS Access 2007)

You can do anything that you like in the VBA Code behind the Password Entry. For instance, you could test the user response, and set the environment according to the Password they have entered.

A question could be raised as to the purpose for doing this. If the reason is to allow some users Read Access only, and no one would ever require the need for both types of access, then you could use a Function to get the user Lan_ID and create a Security Table or a WorkGroup to define which users have which rights.

 

[svcghost]

You can do anything that you like in the VBA Code behind the Password Entry. For instance, you could test the user response, and set the environment according to the Password they have entered.

A question could be raised as to the purpose for doing this. If the reason is to allow some users Read Access only, and no one would ever require the need for both types of access, then you could use a Function to get the user Lan_ID and create a Security Table or a WorkGroup to define which users have which rights.

Do you have any links or tips on how to get started on modifying the native password entry VBA code (upon opening the Access DB)? Some users will have access to both read-only and editable access, while other users will only have read-only access.

 

[MSAccessRookie]

Do you have any links or tips on how to get started on modifying the native password entry VBA code (upon opening the Access DB)? Some users will have access to both read-only and editable access, while other users will only have read-only access.

I am not sure what you mean by "native password entry". If by that you mean that MS Access starts by asking for a Password and the application starts on confirmation of the password, then that means the Application has a Startup form that has VBA Code to control this, and this is the code that you want to look at