ODBC Driver does not support last_insert_id. to get last insert ID in access (e.g. from a PHP script), try SELECT @@IDENTITY