I think you are referring to SCOPE_IDENTITY() http://msdn.microsoft.com/en-us/library/ks9f57t0%28VS.71%29.aspx
However I seem to recall it did not work last time I tried it, but that was ages ago. I think it requires latest version of access and jet drivers. Regards -- Russ Michaels www.cfmldeveloper.com - free CFML hosting for developers my blog: http://russ.michaels.me.uk/ skype: russmichaels -----Original Message----- From: Leigh [mailto:[email protected]] Sent: 24 September 2010 18:16 To: cf-talk Subject: RE: cfinsert/cfupdate > There is a built in method of getting that last records > primarykey for most > databases, but not for MSACCESS. I cannot speak for its reliability, but I believe MS Access does have @@identity. However as shown in one of the previous posts, retrieving the value is a bit more convoluted than in other database types. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337512 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
