How to get the newly generated number from Access table

jeboy

Member
Joined
Nov 19, 2006
Messages
21
Programming Experience
Beginner
How can I get the newly generated number in autonumber field of the current insert query in MS ACCESS? I use Visual Studio .Net 2003 and MS Access as database.

Thanks
 
This is done through Access. Go to access, design view, make a column primary key and assign autonumber as its property. Then, it will show up as autonumber column in vb.net application too!
 
Ziyoda, thats not what I meant. I already created an access database and make its 1 of the columns as primary key and assign autonumber as its property. What I am trying to do is to get the newly generated number of the autonumber field after I execute an Insert query from vb.net
 
Back
Top