I have a program that was using DAO to add records to an Access .mdb File. I just changed it to use ADO to add records to the the same file and I'm getting an error message 'Run-time error 3251 'The operation requested by the application is not supported by the provider'.

The operation is rs.AddNew the provider is Microsoft.Jet.OLEDB.4.0' and the reference library is the 'MS ActiveX Data Objects 2.1'.

I was using 'MS DAO 3.51 object library'. I think the app is still referencing the old DAO obj lib. Has anybody ever seen or heard of this problem before. If you have I could use a solution.
THANKS!!!!!

ps: I downloaded and installed the vb6 runtime files...
and still get the same error.