Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Creating a new record with JET ADO provider.

Creating a new record with JET ADO provider.

Creating a new record with JET ADO provider.

Is it not possible to create a new record in a recordset with the JET 3.51 ADO provider accessing an Access database?
Dim rs as ADO.Recordset
Set rs = New ADO.Recordset
rs.Execute 'SOME SQL QUERY'

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.
Replies continue below

Recommended for you

RE: Creating a new record with JET ADO provider.

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close