How to run a macro as a different user

[maisano]

I have a database with user level security. There are 4 or 5 different levels set up to do all the different tasks.

Most users only have access to a subform on the main page (main form) and none of the fields on the main page. There is a Date Complete field on the main page I want the subform users to fill in once their job is complete.

I have a macro that does the job but will only work if you are logged in with a higher user level ID. You must have New Data permissions for it to work. The macro is located and launched from the subform by a command button.

Is there a way to give that macro permission to fill in the date when launched by the subform user?

I'd appreciate any other solutions as well - it does not have to be the macro - that was just something I thought might work.

Thanks,
Paul

 

[JPeters]

Paul,

Login as the Admin. Find out the users/user group you want to give access to this macro. Now find out what the macro affects (what table it will update, what query it will run, whatever it does). Now go to Tools/Security/User And Group Permissions. Find your group, and give them the appropriate permisions listed.

-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------

 

[maisano]

Josh,

Thanks for the reply. Sorry, I was not clear but I do not want the users who fill out the subform to be able to change anything on the main form (except the Date Complete field). Thats why I thought I would do it with a macro or something to try and get around the current security set up that does not allow them to add anything to that form. I would still like them to be able to add the date only to that form.

The main form contains many other fields that we do not want altered by the subform users.

Thanks,
Paul

 

[JPeters]

masiano,
Do what I suggested above, and then in the form design, simply set the locked properties of the text boxes/check boxes/etc. fields you don't want them to be able to change to True. It's in the properties section under the 'Data' tab near the bottom.
Once locked, these records cannot be altered from the form by the user.

-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------