AutoNumber in Access

  • Thread starter Thread starter Mathew
  • Start date Start date
M

Mathew

I basically have my VB.Net Program written. I was
wondering if I have to do anything on VB.Net end with the
AutoNumber field that I have in Access so it will
automatically update to the next number?
 
Make sure theDataColumn that maps to the autoincrement field has its
AutoIncrement Property set to true. Then, set the AutoIncrementStep to -1
(which will ensure that you never submit values which already exist to the
db). When you submit the update, Access will change the negative values to
conforming ones.

HTH,

Bill
 
Matthew: If you have a field that you don't want updated, you probably want
to keep it invisible from the UI.
 
Back
Top