Switch User

[Guest]

Hi All

Can you please advise me how can I change the logged user, with a different
one,
while the Mdb is open. The mdb is in MsAccess 2000, the change should be by
code (vbe).

Thanks in Advance

 

[Rick Brandt]

Hi All

Can you please advise me how can I change the logged user, with a
different one,
while the Mdb is open. The mdb is in MsAccess 2000, the change should
be by code (vbe).

Thanks in Advance

You cannot. The user is established for the *session*, not the file. You can
execute code that will open a new session as a different user for the purpose of
doing something that requires higher authorities, but you cannot change the user
for the active session without opening a new instance of Access.

 

[Guest]

AHA!!! Another reason I like my own security module better!