This is the error I receive when I run the insert statement.
[Microsoft][ODBC Microsoft Access Driver] Missing semicolon (";") at end of SQL statement. The " around the ; are to keep the smily faces from showing.
You can execute the insert first then execute the @@identity. Or combine these into 1 (separated by a semicolon) sql statement but you would have 2 recordsets to handle. I am not sure if the driver you are using will support multiple recordsets - try moving the semicolon to the end of the insert statement (before the select @@identity).