Database Use

Support is given on the Win2000 platform for Access, DBase and Foxpro databases. We recommend using a DSN-less connection as they are more secure, however, if you wish to use a DSN we give you the option of creating a DSN in the control panel.

It is recommended that you keep your database in a separate directory, after uploading the database to your site you will need to change database permissions via the control panel to make it accessible from ASP or PHP.

Where your database is updated via ASP pages remember to exclude it when publishing changes to your site in FrontPage. In addition please remember to take a regular backup of your database.

Connecting to Access without a DSN (Recommended)

OLE-DB Connection (Recommended over ODBC)

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Request.ServerVariables("APPL_PHYSICAL_PATH") &  "database.mdb;" & _
"UserName=UserName;Password=Password;"

ODBC Connection

"Driver={Microsoft Access Driver (*.mdb)};DBQ=" & _
Request.ServerVariables("APPL_PHYSICAL_PATH") &  "database.mdb;" & _
"UserName=UserName;Password=Password;"