<!--- FOR A SQL DATABASE ---> <cfquery name="rs_MyQuery" datasource="#request.dsn#"> SET NOCOUNT ON INSERT INTO Tbl_MyTable([columns]) VALUES([values]) SELECT MyUID = @@IDENTITY SET NOCOUNT OFF </cfquery> <!--- FOR AN MS ACCESS DATABASE ---> <cftransaction> <cfquery name="rs_MyQuery" datasource="#request.dsn#"> insert into Tbl_MyTable([columns]) values(''[values]') </cfquery> <cfquery name="rs_max" datasource="#request.dsn#"> select MAX (MyUID) AS varMax from Tbl_MyTable </cfquery> </cftransaction>