Databases created in Microsoft Access can be integrated into your website to provide data-driven content.

The following information is for web designers that are experienced script programmers.

PHP can be used with Microsoft Access databases using the ODBC module.  For more details, see this reference.

If you are looking for an easier way to add database information to your website, we strongly suggest you consider using Microsoft FrontPage.  It has built in wizards that can easily incorporate some database capabilities without any programming on your end.

Please note that we do not provide technical support for ASP programming. The following information is presented as a guide for those who are familiar with databases and ASP scripting.

If you need write access to your database, please create a folder in your website to hold your database, publish a sample or skeleton database, and then contact our technical support group to enable write-access to that folder.

We support "DSN-less" mode connection strings for database integration.  Examples below show both the newer OLE DB drivers and the older/traditional ODBC drivers.  For the file location, it is strongly recommended to use relative path names.  (If you must use absolute paths, please contact us for details.) 

OLE DB Connection String:

strConnect = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" &   server.mappath("relpath/filename.mdb") & ";User ID=Admin;"

ODBC Connection String:

strConnect = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("relpath/filename.mdb")