Access Append query--identity key

  • Thread starter Thread starter Elsa
  • Start date Start date
E

Elsa

Hi All,
Do you know how I can retrieve an autonumbered primary key from an Access
saved append query? What I am trying to accomplish is similar to what SQL
server allows one to do when running an insert stored procedure.
Where the insert runs first and then the identity (system-generated) key can
be
retrieved by coding "set @MemberID=@@identity".
Does Access have a way to accomplish this?

Any suggestions and directions are much appreciated.
Thanks,

cstech
 
Back
Top