data source

[richmckinnon]

i have the following in my page. I am stuck on what to put for the data source as when i look at the page on the web it still thinks my database is on my c:

Set objConn = CreateObject("ADODB.Connection&quot
Set objRS = CreateObject("ADODB.Recordset&quot

objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\fpdb\orders.mdb;"
strSQL = "SELECT * FROM orderstatus where orderref=" & ordnum & " and lastname=" & chr(34) & lastnam & chr(34)
Set objRS = objConn.Execute (strSQL)

msgstr = "Order number: " & ordnum & vbcrlf
msgstr = msgstr & "Last name: " & lastnam & vbcrlf
msgstr = msgstr & "Order: " & objrs("order&quot & vbcrlf
msgstr = msgstr & "Status: " & objrs("status&quot
msgbox msgstr,,"dvd-it-all"
objrs.close


For all your vhs/hi8, slides, negatives, transparencies and photos to dvd.

http://www.dvd-it-all.co.uk