How do I do Identity Insert in Access

[Dave]

I have an Access table with an AutoNumber that I want to have a '0' value.

In SQL Server I can do an "Identity Insert" to override a column's Identity
(autonumber) property.

How can I do this in Access 2003.

 

[Guest]

Dave,

You cannot override the AutoNumber of Access as you describe. You also
cannot have a zero value in the auto number.

 

[MacDermott]

I beg your pardon!
I am admittedly operating in Access 2000, but I'd be mighty surprised if
this has changed.
I have a table named MyTable, with an AutoNumber field named ID.
Executing this inserts a row with a value of 0 in ID:
INSERT INTO MyTable (ID) VALUES (0)

 

[Arvin Meyer [MVP]]

I beg your pardon!
I am admittedly operating in Access 2000, but I'd be mighty surprised if
this has changed.
I have a table named MyTable, with an AutoNumber field named ID.
Executing this inserts a row with a value of 0 in ID:
INSERT INTO MyTable (ID) VALUES (0)

Correct, you can insert any long integer into an autonumber field in an
empty Access table if the field is a unique index. The table can have any
value inserted in an autonumber field if it is not a unique index (a rare
occurance, but possible).
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access