Is it not possible to create a new record in a recordset with the JET 3.51 ADO provider accessing an Access database? <br>
e.g.: <br>
Dim rs as ADO.Recordset<br>
Set rs = New ADO.Recordset<br>
rs.Execute 'SOME SQL QUERY'<br>
rs.AddNew<br>
<br>
When I tried something like this I get an error message stating something to the effect of "Service not provided by provider", and pressing 'Debug' highlights the 'rs.AddNew' line in the source code.
e.g.: <br>
Dim rs as ADO.Recordset<br>
Set rs = New ADO.Recordset<br>
rs.Execute 'SOME SQL QUERY'<br>
rs.AddNew<br>
<br>
When I tried something like this I get an error message stating something to the effect of "Service not provided by provider", and pressing 'Debug' highlights the 'rs.AddNew' line in the source code.