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 ?

Arsalan,

You can use an uniquenumber, what is a GUID.

http://msdn.microsoft.com/library/de...wguidtopic.asp

I hope this helps?

Cor

Uniqueidentifier

On Mon, 14 Feb 2005 15:40:26 +0500, "Arsalan" <(E-Mail Removed)> wrote:

¤ 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/de...ementtopic.asp


Paul ~~~ (E-Mail Removed)
Microsoft MVP (Visual Basic)