Creating a new record with JET ADO provider. 1

Katana · Feb 11, 1999

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.

Misled · Feb 26, 1999

The recordset does not have optomistic locking and openkeyset type (I had the same problem as you). The default is read only. You must set it manually or set it as such in the command you use from the DED. I have had a problem getting DED to do server side cursors. I can do server side manually setting these propertys but not with DED. The problem with client side cursors(The default I think, and you will also have the following problem) is that addnew does not immediately give the autonumber field value. You must requery to get it. I want the DED to be set up as a server side cursors in my commands but I get errors when I try it with a server side cursor with the DED.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Creating a new record with JET ADO provider. 1

Katana

Programmer

Misled

Programmer

Similar threads

Part and Inventory Search

Sponsor