For Access (I think anyway) you can not run two statements in the one command.

You should open the connection.
Run the insert command.
Once it returns reset the command text to Select Scope_Identity
and run the command again.

As long as it is on the same connection there is no probblem with this approach.