Passwords

[Rob.Mills]

I am familiar with setting up user-level security. However, I didn't want to set that up for this particular db. What I did though is setup a password for the backend for the purpose of preventing anyone from importing tables out of the backend. But that has added a challenge. Now when someone opens the frontend they can't do anything without getting a message saying "Invalid Password"

Does anyone know how to automatically pass a password when opening the frontend?

 

[PaddyIrishMan]

Hi Rob, Not certain but you could try
CurrentUser = "YourUserName" in the Load event.
CurrentUser is the Access variable where the username is stored.

HTH,
Patrick