Switch User

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Ziv said:
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
Click to expand...

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.
 
Back
Top