https://www.webmaster-forums.net/crss/node/1017886 en https://www.webmaster-forums.net/web-database-development/asp-insert-statements#comment-1104627 <p>If you're using the Jet 4.0 OLEDB provider you should be able to use "SELECT @@IDENTITY"</p> <p>If not there really is no reliable way to get the ID of the last record inserted. If there is always only going to be one person creating records then you could do something like "SELECT MAX(id) FROM table)" after you do your insert.</p> <p>To see a VB example of using the Jet 4.0 OLEDB and @@IDENTITY check out this link: <a href="http://support.microsoft.com/default.aspx?id=kb;;Q232144" class="bb-url">http://support.microsoft.com/default.aspx?id=kb;;Q232144</a></p> Wed, 13 Mar 2002 16:46:07 +0000 Peter J. Boettcher comment 1104627 at https://www.webmaster-forums.net