You may be able to run
in reply to Last Insert ID in MS Access
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
SELECT @@IDENTITY FROM MyTable;
Then retrieve the rowid by fetching from the statement handle, if the DBI driver permits this.
INSERT INTO MyTable (x,y) VALUES (1,2) RETURNING rowid;