Macro Setting Security settings enabled for a list of Users only

[johnpallian]

Dear Friends,

I Know that enabling the macros without security warnings is not recommended in access 2007, But I want to enable them automatically for few users ,

Please help me how can be done,coz it appears whenever the database is opened.

Help me how i can prompt for a user name , and when the user enters the user name the macros are enabled.

 

[Fifty2One]

If you have a table of user names and there is a field indicating if they are or are not permitted to have the macro then in a "Password" text box you could have an If statement under the After Update Event which tests the input against a dlookup for the indicator.

 

[gemma-the-husky]

since each user should have his own copy of access, then he would have his own macro security settings

so this implies you have multiple users sharing a database on a shared drive.

most posters here would strongly recommended you do not run your dbs in this way

 

[johnpallian]

Thanks for response gemma & fifty,

But , It's something like i have to prepare a database and send it to a user through mail , and when the user gets the mail of this database and opens the database he should be prompted for user id , and when he enters id, VBA codes & macros should automatically get enabled,without any warnings

Please help me , coz i dont want my user to see other access objects except the form which is pop-up enabled.
As , when he goes for enabling the macros, he might do experiment with other access objects.

 

[gemma-the-husky]

oh, i see

you need to get each user to change the security setting to low, manually

tools/security/macro/low or some such.

its an access setting, not a database thing

 

[johnpallian]

Thanks dave

But, If i change security setting to low of one access file, will that change settings of all other files in the PC.??