When setting up a DNS-less connection to an Access .mdb file, it is better to use a relative path, rather than a physical path, to the database. This is bacause the physical location of your website could change over time.
Using ASP's Server.MapPath, you can setup a data source name (DSN), as shown in the example below.
DSN_NAME = "DBQ=" & Server.MapPath("/database/mydatabase.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"
Article ID: 493, Created: March 9, 2011 at 6:23 PM, Modified: March 9, 2011 at 6:23 PM