Append query to change the value of an autonumber field

[Remy]

Hi,

I tried to change the starting value of an autnumber field (which is also
the key primary key of the table) with an append query (following the
instructions of the help topic) but it doesn't work at all.

The fact is that I want to change the starting value of an Order ID
(autonumber and primary key field), so I created a temporary table with the
value I want less 1. Here is the SQL statement of the query:

INSERT INTO Orders ( [Order ID] )
SELECT [Temporary table].[Order ID]
FROM [Temporary table];

What is wrong with it? Anyone knows?

Remy

 

[KARL DEWEY]

Try removing the leading and trailing spaces you have around ( [Order ID] )
to look like this --

INSERT INTO Orders ([Order ID])