<div>
also you could use<br />
<br />
SELECT Max(RecordID) as LastAutoID FROM Table1 <br />
<br />
to get the last ID inserted. But if you are using Access 200 or higher, I recomment using @@IDENTITY
</div>


also you could use

SELECT Max(RecordID) as LastAutoID FROM Table1

to get the last ID inserted. But if you are using Access 200 or higher, I recomment using @@IDENTITY

<div>
<div class="content wysiwyg-content">
I'm currently developing a VB.net win forms application. &nbsp;This application uses MS Access 2000 for the database. &nbsp;When inserting into a table, the primary key is an autonumber. Then I need to insert this autonumber into this other table. &nbsp;This autonumber is a foriegn key in this other table. &nbsp;Is there an easy way to get what the value of the autonumber of the table at the time of insert, or do I need to write a query to retrieve this value. <br />
<br />
Thanks,<br />
Brian
</div>
</div>


I'm currently developing a VB.net win forms application.  This application uses MS Access 2000 for the database.  When inserting into a table, the primary key is an autonumber. Then I need to insert this autonumber into this other table.  This autonumber is a foriegn key in this other table.  Is there an easy way to get what the value of the autonumber of the table at the time of insert, or do I need to write a query to retrieve this value. 

Thanks,
Brian

Accessing MS Access through VB.NET

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,