ImpersonateUser in VBA , Need to verify the credentials as well

[naganesan]

Please help me to create a VBA code in Access to run the program using my admin credentials to do modify tasks.
I want know if the login is successful or not , and log off in the end of the program.

Please help, Its urgent !!!!!

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!

 

[Gasman]

For others, the query is from this thread
https://www.access-programmers.co.u...which-msaccess-can-acces.196037/#post-1776106

 

[isladogs]

Some questions:
1. Do users login with username & password with each having different security levels? If so, its very easy to test.
2. Or are you using their network login to detect their user name using e.g. the Environ variable. If so, it can be spoofed for testing purposes
3. Have you considered using code to detect whether Access is being Run As An Administrator? If true, the user could be allowed to do certain tasks, but not otherwise.

Are you the developer of the app? If so, what have you tried so far?

 

[jdraw]

In addition to the comments provided so far, can you describe the business being automated in simple English to assist readers with context.
Also, it may be helpful if you describe the urgency and your role to get focused responses.

 

[Isaac]

Two more options for impersonation, using nothing except VBA and free/windows command line :

• psexec
• RunAs

... Both of which you can control using command line programming, which can easily be ran using VBA.

 

[theDBguy]

Hi. Since this is the Introduction Forum, welcome to AWF!