Microsoft Access is part of the Microsoft Office suite of applications and is a database that is suitable for low-usage web sites. The Access database is stored in an MDB file, eg mydatabase.mdb
Although there are many different ways of using an Access database we have documented an example for the convenience of our users. This knowledgebase article is a specific example, and you will need to adjust file names and other things as appropriate. This example is how to connect to an Access database from an ASP script.
strConnection = "PROVIDER=Microsoft.Jet.OLEDB.4.0; DATA SOURCE=c:\domains\mysite.com\db\mydatabase.mdb;"
Set dbCon = Server.CreateObject("ADODB.Connection")
Set rst = dbCon.Execute("SELECT * FROM MyTable;")