alter table with autoincrement field

I am attempting to update an oracle table using MS Access.

One of the fields to be updated is a primary key number field.

I'd like to use the autoincrement field to update that field.



My sql is:

Code:

---

Alter table testAutoNum Add column progid autoincrement (1001,2)

---

This sql nicely creates the new field in the table, but it doesn't start at 1001 and increment by 2; it starts and 1 and increments by 1.

It is also creating an autonumber and I need it to be a number.



What am I doing wrong?



Thanks.

alter table with autoincrement field