Start Auto_Increment at a higher number

[Joeandtel]

Is there a way to start the Primary Auto_Number at a specific number? Usually it starts at 1, but I would like to have it start at 5,000

[Ray at]

What kind of database? If SQL, look at "DBCC CHECKIDENT" in the BOL. Or
probably better, ask in a SQL newsgroup, as I'm no SQL Server expert.

Ray at work

"Joeandtel" <an*******@discussions.microsoft.com> wrote in message
news:95**********************************@microsof t.com...

Is there a way to start the Primary Auto_Number at a specific number?

Usually it starts at 1, but I would like to have it start at 5,000

[Dave Anderson]

"Joeandtel" wrote:

Is there a way to start the Primary Auto_Number at a specific number?
Usually it starts at 1, but I would like to have it start at 5,000

If SQL Server this will work:

CREATE TABLE [dbo].[TableName] (
[ID] [int] IDENTITY (5000, 1) NOT NULL ,
...
)
--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

[Chris Hohmann]

"Joeandtel" <an*******@discussions.microsoft.com> wrote in message
news:95**********************************@microsof t.com...

Is there a way to start the Primary Auto_Number at a specific number?

Usually it starts at 1, but I would like to have it start at 5,000

Dave provided the answer if your database is MS SQL Server. If it's
Access then you can:

1. Insert a record with an explicit auto-number value:

INSERT INTO
Foo
(
ID,
Bar
)
VALUES
(
4999,
"Kilroy was here"
)

2. Delete the inserted record

The next record will start at autonumber 5000.

Note: Your question leads me to believe that you intend to attribute
some meaning to your autonumber field. I would advise against this.
Autonumber fields should be non-meaningful, ie. their only purpose is to
provide a way to uniquely identify each record. They should not be used
for things like rank, order, weighting, etc.. Those belong in fields of
there own.

HTH
-Chris Hohmann