Getting the primary key for a record inserted into Access

[Guru2B]

Hi,

Can anyone tell me if there is a way to get the primary key of a newly inserted record from the database? I am using ADO 2.5 to connect to the DB with VB 6.0.

I know that with DAO, I could get the primary key before calling the update method, but this doesn't seem to work with ADO.

Please help!
Thanks.

 

[Morpheus1981]

If u declare ADO as a variable
dim dcnDB as ADOBD.recordset
for example, then add the key word withevents, this will let u use several procedures maybe one of the is what u r looking for.

If ur using tghe dataenvironent just doble click the command and then look for the event that u want.
Check this out.It is very helpful.