run vba script as admin, logged as regular user

[gangac]

We have an existing MS application /database which creates reports when i am logged in as admin.. however, i want to login as a different user with minimal privileges on the forms /underlying tables..dont want user to see the tables/forms..and run all the underlying vba code as admin.. Is that possible if so how..i want the user to have flexibility in storing this database on any directory they wish..

thanks and regards,

chandran gangadharan
toronto, canada

 

[sabsfilho]

Have you solved it ?

I am having a similar problem.

I need to allow a regular user to save a csv file into an admin restricted directory from a command dispatched by an Access button.

Meanwhile I am trying a solution using an ActiveX DLL that I build. I have read something about WMI and I am testing if it could help.

Have you discoreved a way to get it done ?

Regards!

Samuel Santos
Rio - Brazil

 

[JBurlison]

what ver of access are you running?

 

[sabsfilho]

The ACCESS version is 97 SR-1

Actually, I decided to not use WMI. I am trying an idea based on ADSI but I haven't finished yet.

I am not sure if it is the best approach.

If you have a clue, share it please.

Thanks!