DSN-less connection to MS Access Database

Sample of DSN-less connection string for MS Access database: You can create sample test aspx file for this connection string, for example conn.aspx inside wwwroot directory. The actual sample is:

Dim conStr,path   path=Server.MapPath(".")   path=replace(path,"\wwwroot","")   path=path & "\data\database.mdb"   conStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path

The ms access database file should be located in directory data. Use the actual name of your database instead of database.mdb.