Unfortunately, last_insert_rowid is not supported by the ODBC driver. When I need to do this I query for what I just inserted and get the ID that way.

I hope another monk can prove me wrong, as this approach is a bit cumbersome.


In reply to Re: Last Insert ID in MS Access by bobf
in thread Last Insert ID in MS Access by greyhawk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":