User authentication, login forms, and the EqlUsers table

Updated 2010-03-12 | Filed under OnWeb | PDF

Question

How can I control who can log into my EQL Access OnWeb database via their web browser?

Answer

Here are two different ways to do it, depending on how you want your system to work.

Create your own Password form in Access

The simplest way to protect your web database is to do it yourself using your own set of custom Access forms.

Just create a set of usernames and passwords and a login form, then set it as the Startup form for your database. You can have your form open your main form only if authentication succeeds.

EQL OnWeb ensures any startup form cannot be bypassed by a user connecting to the application.

HTTP authentication

EQL OnWeb also supports HTTP authentication to control logins to the OnWeb administrative interface and database. In order to enable HTTP Authentication, follow this simple procedure:

  1. Create a database table called EqlUsers with text columns named Username and Password. (You can also add additional columns like a full name and description, for example, but they'll be ignored by EQL.)

  2. Populate the table with all the desired logins and passwords.

  3. Using the EQL plugin, synchronize your database with the OnWeb server.

From now on, all logins to the database and administrative database will be protected via HTTP authentication.

Within your web database, you can determine which user has logged in via the 'Environ' VBA function, as in the following code: 

Dim user as String
user = Environ("EQL_USERNAME")

Typically, HTTP authentication is coupled with HTTPS support, available for an extra cost.

Please contact support@eqldata.com for questions or clarification.

Related Articles

Unrelated Articles