Creating a new record with JET ADO provider.
Creating a new record with JET ADO provider.
(OP)
Is it not possible to create a new record in a recordset with the JET 3.51 ADO provider accessing an Access database?
e.g.:
Dim rs as ADO.Recordset
Set rs = New ADO.Recordset
rs.Execute 'SOME SQL QUERY'
rs.AddNew
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.:
Dim rs as ADO.Recordset
Set rs = New ADO.Recordset
rs.Execute 'SOME SQL QUERY'
rs.AddNew
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.
RE: Creating a new record with JET ADO provider.