http://qs321.pair.com?node_id=850063


in reply to Last Insert ID in MS Access

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.