am struggling to get the scope identity in MS Access.
its returning an error 'Character found at the end of statement'.

Adapter : OLEDB

Code:
INSERT INTO Leads (firstname, lastname) VALUES ('Bill', 'gates'); SELECT SCOPE_IDENTITY()"