Using VB Script to access an MDB file

[computerman]

I am new to writing vbscript and I was wondering how I would access an MDB file displaying multiple lines on a web page.

Can someone give me a skeleton script which I could manipulate to suit my own needs.

Any help would be appreciated.

Computerman

[Teranoz]

Use ADO or OLEDB with the proper connectionstring
http://www.connectionstrings.com/

Dim CN, RS, SQL
Set CN = Server.CreateObject("ADODB.CONNECTION")
Set RS = Server.CreateObject("ADODB.Recordset")
SQL = "Select * from thetableyouwant where whatever = 5 order by whoknows desc"
CN.Open ConnectionString
RS.Open SQL,CN,adForwardOnly,adReadOnly
While not RS.EOF
response.write "<tr><td>" & RS.Fields(0) & "</td><tr>"
RS.Movenext
Wend
RS.Close
CN.Close
Set CN = nothing
Set RS = nothing

[computerman]

Many thanks, I will try that.

Computerman