This is where I appear to be a complete boffin! No one saw me looking it up did they?
That puzled me at first too but with a little help from my friends (well t'was "Beginning ASP Databases" from WROX actually...not trying to plug them or anything but I've found it really useful. :) )
Ok...
Code:
dim oConn
set oConn = Server.CreateObject("ADODB.Connection")
oConn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};"
oConn.ConnectionString = oConn.ConnectionString & "DBQ=" & Server.MapPath("\MyWebDB.mdb") & ";"
oConn.ConnectionString = oConn.ConnectionString & "PWD=Will"
oConn.Open
How's that sound? Works for me...
You can then use something like:
Code:
Dim oRS
Set oRS = Server.CreateObject("ADODB.Recordset")
oRS.Open TABLENAME/SQL STATEMENT, oConn
Erm...Ok,,,let me think :)
I think:
Code:
oConn.ConnectionString = "Provider=Microsoft.Jet.4.00; "
oConn.ConnectionString = oConn.ConnectionString & "Data Source=" & Server.MapPath("\MyWebDB.mdb") & "; "
oConn.ConnectionString = oConn.ConnectionString & "pwd=Will"
Haven't had chance to test that but I think it's about right :) You may need to use "Password=Will" instead of "pwd=Will".