autonumbering with update command

I made an application that uses datasets to edit/insert/delete data from an Access database and then use the update command to update the database. In my database the id field of my table is an autonumbering field. When I add a row to my dataset, fill it, and use the update command to insert it in my database, I need to somehow retrieve the id field value that my database set during the insert command and put it in my dataset. Is that possible?

Thank you.

Who is Participating?
CetusMODConnect With a Mentor Commented:
Closed, 75 points refunded.
Community Support Moderator
dotarjAuthor Commented:
I found the solution here:

I will ask a moderator to close the question.


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.