What is the path to my database folder?

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)};"

Add Feedback