Please see following, example,Can I creat a remote a recordset from Msaccess .mdb file? If yes how to change following to right one?
the following example is not work.
<PARAM NAME="CONNECT" VALUE="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\xqweb\Bat3\ojt_new\ojtnews\OJTNEWS.mdb;" >




<SCRIPT LANGUAGE=vbscript>
<!--
Sub FillVarietyList
Set R = VList.Recordset
Do Until R.Eof
Set O = document.createElement("OPTION")
O.Text = R(0)
VarietyList.add O
Set O = Nothing
R.MoveNext
Loop
VarietyList.disabled = false
End Sub

Sub window_onload
FillVarietyList
End Sub
-->
</SCRIPT>

<HTML>
<OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33" ID="VList" HEIGHT=1 WIDTH = 1>
<PARAM NAME="SQL" VALUE="SELECT ID FROM ADDNEWCOURSE">
<PARAM NAME="SERVER" VALUE="http://xiqing.sps.mot.com">
<PARAM NAME="CONNECT" VALUE="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\xqweb\Bat3\ojt_new\ojtnews\OJTNEWS.mdb;" >

</OBJECT>

<SELECT ID="VarietyList" disabled></SELECT><P></BODY></HTML>