How get Identity of newly added record without using Stored Procedure?

  • Thread starter Thread starter VB Programmer
  • Start date Start date
V

VB Programmer

I am using ADO.NET to insert a record into an ACCESS database.

How do I get the Identity of the newly added record without using a stored
proc?

Thanks!
 
VB said:
I am using ADO.NET to insert a record into an ACCESS database.

How do I get the Identity of the newly added record without using a stored
proc?

Thanks!
Click to expand...
Just execute straight after SELECT MAX(ID_FIELD) FROM TABLE_NAME

Selim
 
¤ I am using ADO.NET to insert a record into an ACCESS database.
¤
¤ How do I get the Identity of the newly added record without using a stored
¤ proc?

See the following:

HOW TO: Retrieve the Identity Value While Inserting Records into Access Database By Using Visual
Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;815629


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top