How do I get the auto number after an INSERT in Ms Access?
- by Justin Tanner
I have query in vbscript like this:
DoCmd.RunSQL "INSERT INTO table (value) VALUES ('example')"
( with an auto incremented primary key called id)
How can I get the auto incremented id generated by this insert?