Access 2016 Logon

Question

How can I have a logon form on a server for Access 2016?

Regards

Answer 1

This is something you have to develop yourself.

You can create very simple login forms that validate against a single db password (then again just encrypt the db if that is what you are after) or much more advanced role based login systems.  Everything depends on your needs.  Take a look at http://www.devhut.net/2012/12/21/ms-access-login-form/ where I posted links to several sample login databases.  Check them out and use the one that suits your needs best.

Answer 2

Please see my blog on Login Security with VBA (blog address below). it has full details on creating a login form and securing your application.

I am curious what you mean bu "on a server"? Access applications should be split into a back end (tables) and a front end (everything else). The front end is installed on each user's PC and the back end is on a shared drive. The login form and security would be in the front end.

Answer 3

You'd have to build that yourself, since Access does not have this built-in.

Create a form that has two textboxes (txUser and txPass), and a button (cmLogin). 

In the cmLogin button do this:

If txPass = "YourPassword" Then

  <password is correct, so do something here>

End If

Of course, if you store usernames and passwords you'd have to look that up in the table. 

If txPass = DLookup("Password", "Users", "UserName='" & Me.txUser &"'")

End If

You also mention a server. In general, anything that would be logged in to should be stored on the local user's hard drive, and should NOT be accessed from the server. It's fine to have the data portion of your application on a server, but the user interface portion should always be stored directly on the local hard drive.