SetRootRecordset Not updateable

[99Chuck99]

Hi All,
Not sure if I'm in the right forum, But here is my question/problem. I'm using a Access Data Page. When the page opens I can update the records shown. I then use dropdownlist to gather parameters and then set the rootrecordset for the page. Data refreshes and it pulls the records I want but I can not update them now. Is there something I need to set or refresh to all these to become updateable. I have tested the setrootrecordset to be the same as when the page originally open so I dont think is has anything to do with the actual recordset. Key fields are there. Any help on this would be greatly appreciated...

strConnectionString = "Provider=MSDataShape;Persist Security Info=False;Data Source" _
& "=\\Kscboc2\Share\Jbosc\Rpi\Databases\VALIDATION.mdb;User ID=Admin;"_
& "Data Provider=Microsoft.Jet.OLEDB.4.0"



Set rstWEBVALIDATION = CreateObject("ADODB.Recordset")
rstWEBVALIDATION.Open strShapeSQL, strConnectionString, 1, 3
msgbox rstWEBVALIDATION.RecordCount
MSODSC.SetRootRecordset "WEBVALIDATION", rstWEBVALIDATION
MSODSC.RefreshJetCache