Ok my situation is that I would like to benefit from RDS data binding with MS Access. I am looking at Pro ASP 3.0 Chapter 10 which has a lot of good examples, except they are all coded for MS sequel server.

I am able to get data from my DB if I use the following type of object in an ASP file, where I open a recordset in UserPage.asp (code also below),

<OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
        ID="dsoData" HEIGHT="0" WIDTH="0">
  <PARAM NAME="URL" VALUE="UserPage.asp">
</OBJECT>

"UserPage.asp"
Dim rsData
Set rsData = Server.CreateObject("ADODB.Recordset")
rsData.Open "SELECT * FROM tblUsers", Cnn
rsData.Save Response, adPersistXML
rsData.Close
Set rsData = Nothing

but if I try to save data with a handy save button I get no results on the database .

<BUTTON ID="cmdUpdateAll" TITLE="Save All Changes"
    ONCLICK="dsoData.SubmitChanges()">Save</BUTTON>&nbsp;

I am assuming there is a problem with the way I create the object.

IN the book they set up the object in the following manner,

<OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
        ID="dsoData" HEIGHT="0" WIDTH="0">
<PARAM NAME="Connect" VALUE="<%=strConn%>">
<PARAM NAME="Server" VALUE="http://<%=Request.ServerVariables("SERVER_NAME")%>">
<PARAM NAME="SQL" VALUE="SELECT * FROM tblUsers">
</OBJECT>

but my MS Access DB is local for the moment and I am using the following code to open it

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=C:\DataStore\test.mdb"

Can anyone help me with a solution?