Passing @@Identity back to VBA

[LeanneGodney]

Hi there,

Does anyone know how to grab what the @@Identity value is once you've run an append query and use it in VBA? I'm guessing at this point I'd have to use a function to do the append and return the @@IDentity?

Thanks,
Leanne

 

[cmmrfrds]

On the same connection right after the insert sql, do a select on the identity.

cn.execute "your insert"
cn.execute "Select @@scope_identity"

Better to use scope identity.