<div>
I personally never use the autonumber feature of any database. You can check out my answer to Q.10104529, my sample uses another table to hold the last used ID for a given table. By using your own ID number routine you have more control of the ID's and a number won't be re-used if the record is deleted and the database is compacted.<br />
<br />
URL for Q.10104529:<br />
<br />
<a href="https://www.experts-exchange.com/topics/comp/lang/vbdatabases/Q.10104529" rel="ugc nofollow">https://www.experts-exchange.com/topics/comp/lang/vbdatabases/Q.10104529</a><br />
<br />
[-Note- the sample uses DAO - so I am performing a seek rather than opening a resultset but the concept is there.]<br />

</div>


I personally never use the autonumber feature of any database. You can check out my answer to Q.10104529, my sample uses another table to hold the last used ID for a given table. By using your own ID number routine you have more control of the ID's and a number won't be re-used if the record is deleted and the database is compacted.

URL for Q.10104529:

https://www.experts-exchange.com/topics/comp/lang/vbdatabases/Q.10104529 [https://www.experts-exchange.com/topics/comp/lang/vbdatabases/Q.10104529]

[-Note- the sample uses DAO - so I am performing a seek rather than opening a resultset but the concept is there.]


<div>
As it turrns out - I was originally specifying a CursorLocation of adUseClient for my recordset . I switched to adUseServer and my autonumber ID was then visible after &nbsp;the update method.<br />

</div>


As it turrns out - I was originally specifying a CursorLocation of adUseClient for my recordset . I switched to adUseServer and my autonumber ID was then visible after  the update method.


<div>
<div class="content wysiwyg-content">
Using ADO &nbsp;2.0 &nbsp;and Access 97 - How can you find out what the autonumber &nbsp;id of a record just added is? There is no Lastmodified property for an ADO recordset.
</div>
</div>


Using ADO  2.0  and Access 97 - How can you find out what the autonumber  id of a record just added is? There is no Lastmodified property for an ADO recordset.

ADO - ? autonumber after update

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.