AddNew method in ADO is different than in DAO...

[Sergio Duenas]

I use a DAO control to access a table in a Access database. The table has
an ID field which is autonumber.

When using the AddNew method in DAO, the ID is generated right away. However,
in ADO it is not generated until the Update method is executed.

Any idea on how can I have the ID value at the time the AddNew method (ADO)
is executed ?
Thanks,

[Justin Spencer]

Try this Sergio, it seems to work well for me (VB6sp3 ADO2.5)

dim lngNewUID as integer

rs.update
rs.requery
lngNewUID = rs!ID

Good luck


"Sergio Duenas" <sergio_duenas@hotmail.com> wrote:
>
>I use a DAO control to access a table in a Access database. The table has
>an ID field which is autonumber.
>
>When using the AddNew method in DAO, the ID is generated right away. However,
>in ADO it is not generated until the Update method is executed.
>
>Any idea on how can I have the ID value at the time the AddNew method (ADO)
>is executed ?
>Thanks,
>
>

[Charles Corcoran]

Check the cursor, see..
PRB: AutoNumber Field Is Not Incremented When Using ADO
ID: Q190370

Charles Corcoran




"Sergio Duenas" <sergio_duenas@hotmail.com> wrote:
>
>I use a DAO control to access a table in a Access database. The table has
>an ID field which is autonumber.
>
>When using the AddNew method in DAO, the ID is generated right away. However,
>in ADO it is not generated until the Update method is executed.
>
>Any idea on how can I have the ID value at the time the AddNew method (ADO)
>is executed ?
>Thanks,
>
>