Auto Number Seed ?

  • Thread starter Thread starter Arsalan
  • Start date Start date
A

Arsalan

How can I reset or change the value of autonumber in MS Access ? Doesn't it
have the function like NEXTVAL or CURVAL as in Oracle ? Or is autonumber
field more rigid ? Or is it possible to make sequence in Access so I can
manually do it ?
 
¤ How can I reset or change the value of autonumber in MS Access ? Doesn't it
¤ have the function like NEXTVAL or CURVAL as in Oracle ? Or is autonumber
¤ field more rigid ? Or is it possible to make sequence in Access so I can
¤ manually do it ?
¤
¤

The autoincrement data type in MS Access and SQL Server is different than Oracle. There is no need
to call a function, it is generated automatically upon insert of a new row.

You can use an AutoIncrement Column on the client, with ADO.NET, but then that would preclude you
from using a corresponding column of that type at the database level.

http://msdn.microsoft.com/library/d...stemdatadatacolumnclassautoincrementtopic.asp


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