Right, that's why I used @@identity in the first place.

But here's another issue that's driving me crazy; The following code works just fine.
>>

>>lcSourceFile = "C:\projects\FRS\FRS5Data.accdb" 
>>pnConnHandle = SQLSTRINGCONNECT("Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + ;
>>   					  				  lcSourceFile)
>>TEXT TO lcSQLCommand NOSHOW
>>INSERT INTO [TblHousehold] (SYSTEMPROGRAMCD, PROGRAMCD,LSTUPDTDTTM) VALUES (?m.sysprogcd,?m.programcd,?m.lstupdtdttm)
>>ENDTEXT
>>
>>lnResult = SQLEXEC(pnConnHandle,lcSQLCommand)
>>

But this below blows up with an error "Connectivity error: etc. Too few parameters. Expected 1."

TEXT TO lcSQLCommand TEXTMERGE NOSHOW
INSERT INTO [tblHouseholdMember] (HOUSEHOLDSEQNBR,HOUSEHOLDVERSIONNBR,PERSONSEQNBR,LASTNAME) VALUES (&lt&ltlnHouseholdSeqNbr&rt&rt, &lt&ltlnHouseholdVersionNbr&rt&rt, &lt&ltlnPersonSeqNbr&rt&rt,&lt&ltm.lastname&rt&rt)
ENDTEXT	

Where the contents of the Watch window for lcSQLCommand after the Text Merge are

"INSERT INTO [tblHouseholdMember] (HOUSEHOLDSEQNBR,HOUSEHOLDVERSIONNBR,PERSONSEQNBR,LASTNAME) VALUES (893, 1, 1,Kinch               )"

So what the heck is up with that?