T
Tony_VBACoder
In my Access 2002 database with WinXP, prior to applying
security to the application, I had all the user's in a
table with all their login names and passwords. I created
a custom login screen where the user could log in and log
out of the application without having to close down
Access. This allowed different users to be able to use
the application on the same PC, without having to close
Access each time a new user wanted to log in.
Now, with the Secure database, I placed the icon that the
Security Wizard created on the desktop, which has the path
to the Access database and MDW file, where the user's
click to log into the application. My question is, is
there a way, with VBA code, to have the same logout/login
functionality with the secure database without having to
Exit Access? So far, I have had to completely exit Access
and then restart the application via the icon, if I wanted
to log in as a different user.
security to the application, I had all the user's in a
table with all their login names and passwords. I created
a custom login screen where the user could log in and log
out of the application without having to close down
Access. This allowed different users to be able to use
the application on the same PC, without having to close
Access each time a new user wanted to log in.
Now, with the Secure database, I placed the icon that the
Security Wizard created on the desktop, which has the path
to the Access database and MDW file, where the user's
click to log into the application. My question is, is
there a way, with VBA code, to have the same logout/login
functionality with the secure database without having to
Exit Access? So far, I have had to completely exit Access
and then restart the application via the icon, if I wanted
to log in as a different user.