Run-time error 3326

[dvannoy]

I have a form based off a query. It's been running fine for months..all of the sudden i am getting the Following message.. Run-time Error 3326 This Recordset is not updatable...what would casue this?? and how can i fix it..

Thanks DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[pcdaveh]

I'm assuming that this form is somehow connected to a query. I'm not sure if your using bound or unbound controls but whatever query your using try making this change. In the query properties Record set Type make sure it is set to: Dynaset (Inconsistent Updates.)

 

[dvannoy]

Thanks...that worked...but why all of the sudden would that be an issue?? I could not find any info on Microsoft's web site.. DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[pcdaveh]

I'm not really sure without seeing it and knowing the full history. I myself had the same question a few years ago and someone helped me. I just know it works.