DSN-Less Connection

[Leeus]

I am currently using "Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\folder\mydb.mdb;" which works fine, is there one for a file in the same folder as all asp files, I have tried I am currently using "Driver={Microsoft Access Driver(*.mdb)};Dbq=mydb.mdb;" Which doesn't work!

[Mhtml]

"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="&Server.MapPath("myDb.mdb")&";"

[Leeus]

Getting some errors in DW MX, any tips for this bloody annoying program, trying to set it up for a client!
Here is the error http://www.leeus.co.uk/images/error.gifhttp://www.leeus.co.uk/images/error.gif

[victoria_1018]

You can try this:

"driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("\Name Of Folder") & "\Database.mdb"

[whammy]

Yeah, actually if you're using access, you need to have your access database above the root of your web directory (like they do it on brinkster.com) so noone can just download your database!

In order to do that you need to use Server.MapPath() to map the file path locally.

:)

[Mhtml]

I can never get DW MX to recognise my connections, I would use dsn but I am always mucking around with new databases instead of adding to existing ones.