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.
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.