Couldn't get @@IDENTITY to work on the Access Database - it keeps returning value of '0' as the new ID - although I did find the following which provided an alternative: http://support.microsoft.com/default.aspx/kb/221931 Can anyone confirm that as Jason and http://www.drdev.net/article06Print.htm say, that @@Identity can be used on Access? All I got were values of '0' and no errors. Thanks anyway Jason - your first link led me to find the link to MS KB Article which worked for me. Chris. -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Chris Dempsey Sent: 16 August 2006 15:30 To: thelist at lists.evolt.org Subject: Re: [thelist] Pausing ASP script when no acces to SQL server > Why not use @@IDENTITY I had seen this come up before but the same article also said it was only suitable for SQL Server databases?? Will read up on the MS Knowledgebase article you linked. Thank you. Chris. -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of jason.handby Sent: 16 August 2006 15:10 To: thelist at lists.evolt.org Subject: Re: [thelist] Pausing ASP script when no acces to SQL server Hi Chris, > I require to pause an ASP script for around 1 second after > doing a database insert so I can grab the unique ID from the > new record in an access database > using: SELECT MAX (itemID) AS maxID FROM tblItems" > > If I don't pause the script I get the previous maxID. You absolutely don't want to do this!!! Why not use @@IDENTITY to get the unique ID of the last inserted record? http://support.microsoft.com/kb/232144/EN-US/ Jason -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !