FAQ

Where is the database?

The file named ajlogin.mdb is a Microsoft Access Database. All user information is stored in this file.

Which values should I change in inc_config.asp?

You should set all the variables in inc_config.asp to values appropriate for your site with the exception of the variables in the "Please do not edit settings below this line" section.

The inc_config.asp file has notes on each of the settings directly above the corresponding variable.

THE MOST IMPORTANT VALUE TO CHANGE IS THE PATH TO THE DATABASE. IF THE SCRIPT CANNOT FIND THE DATABASE, IT WILL NOT FUNCTION.

I moved my database to an offline folder. How do edit the path so the asp script can find it?

Edit the ajlogin_dsn value in inc_config.asp

Assuming that the offline folder is c:\database, the new string would look like this:

ajlogin_dsn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\database\ajlogin.mdb"

I followed the directions and the page is still unprotected!

Does your server support classic ASP (ASP 3.0)? Be sure to check with your web hosting service provider.

AJLogin can only protect pages with the .asp extension and will not protect pages with a .htm or .html extension.

Assuming your web host supports ASP, there is usually no harm in renaming a .htm/.html file to .asp for the purposes of protecting it.

WARNING: Renaming the files that make up your web site will obviously cause links to those pages to break.

Why does a page say "Error: ActiveX component can't create object: 'CDONTS.NewMail'" or "Error on Server.CreateObject"?

Your server most likely does not have CDONTS installed.

To use CDOSYS (the successor to CDONTS) to send AJLogin e-mails, set ajlogin_usecdonts = false in inc_config.asp.

Why am I getting the following error: "Microsoft JET Database Engine error '80004005' - Operation must use an updateable query."?

In most cases, this error is caused by incorrect permissions on the database file and/or the folder in which the database resides.

Make sure the database file and it's parent folder have read and write permissions set. If your site is hosted remotely, contact your web host and have them modify the permissions for you.

How do I add form fields?

You'll need to manually create new columns in the members table in the database to hold the new data - one column for each desired field.

Then, add a new field object for each desired field to the MemberFields object in the Public Sub InitFields subroutine which is defined in the inc_common.php file.

Phone Number Example:

oField.FieldType = "Text"                       'Possible values are "Number" or "Date" or "Text"
Set oField.FormItem = New MemberFormItem
oField.FormItem.IsMemberEditable = true         'Set this to false if the value should only be editable by admins.
oField.FormItem.InputLabel = "Phone number"
oField.FormItem.InputName = "MemberPhoneNumber" 'This doesn't have to match the FieldName property, I just like the convention.
oField.FormItem.InputType = "text"              'Only input types that use the <input> tag are supported. <textarea> and <select> are not currently implemented.
oField.FormItem.InputClass = "text-input"       'The CSS class applied to this <input> field. Separate multiple classes with a space.
oField.FormItem.Required = true                 'Require the user to enter a value for this for item?
MemberFields.Add oField.FieldName, oField
Set oField = nothing