[AccessD] Custom autonumbering

Thanks Drew. Didn't know it was that simple. In T-SQL you would have to use
SET IDENTITY INSERT ON before explicitly setting a value for an Identity
field. Quite new to me that you can just use an INSERT statement on an
AutoNumber field in Access.
Now your two-table approach is certainly an alternative to consider for me.

Asger

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af Drew Wutka
Sendt: 2. juli 2009 05:01
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] Custom autonumbering

#2 is pretty easy to...

INSERT INTO tblOrderNumber ([OrderNumber],[OrderID]) VALUES (20098000,0)

Then

DELETE * FROM tblOrderNumber WHERE tblOrderNumber=20098000

And whalla, your next OrderNumber will be 20098001

Drew