What I have here is the basics for connecting to a database. I have done a bit of ASP stuff and I don't know if it is the same but you can try.
Code:
' * Database connection Strings * '
strdbname = databse.mdb
' * Open Database * '
Set oConn = CreateObject("ADODB.Connection")
oConn.Open ("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & strdbname & ";")
strdbsql = "SELECT * FROM tablehere ORDER by " & 'variable here
Set oRS = oConn.Execute(strdbsql)
' * Close Database * '
oConn.Close
Set oRS = Nothing
Set oConn = Nothing
No one has replied yet! Why not be the first?
Sign in or Join us (it's free).