in reply to
Last Insert ID in MS Access
You may be able to run
SELECT @@IDENTITY FROM MyTable;
and pass that through to the underlying table. I found it by googling for MS Access and last insert id. One would think the DBD::ODBC
documentation should help too, but I found it a bit opaque on this topic. In many advanced SQL dialects you can also say something like
INSERT INTO MyTable (x,y) VALUES (1,2) RETURNING rowid;
Then retrieve the rowid by fetching from the statement handle, if the DBI driver permits this.