Autonummerering skal ændres til anden værdi

I havent tried this but you can give it a try.

Alter the autonumber to a Number field (long Int) and remove the primary key.

Now you can make an Update query something like this.

UPDATE YourTable SET ID = ID+1000

Run the update query.

Now alter the ID to an Autonumber and set it to Primary Key

If you have related tables (foreign key) then these will need updating too

Just tried it, you can NOT alter back to an autonumber :o(

can you give a link to the article you have read

Here is a solution

Alter the autonumber to a Number field (long Int) and remove the primary key.

Now you can make an Update query something like this.

UPDATE YourTable SET ID = ID+1000

Run the update query.

Now make a copy of the table withoutthe data (structure only). Alter the ID to a Autonumber.
Now make an append query which takes the data from your original table and puts it into the new table. Now delete the original table and rename the new.

Alter the ID to a Autonumber. (this is for the NEW table)

In the danish version it have the titel
"Ændre startværdi i et stigende felt af typen autonummerering"

herch>I understand danish 99.99% so you can make comments in danish.

You can quite easily change the start value if no data already exists. But because you alreday have data then it is NOT so easy.

I think you should try my suggestion I made 14/02-2004 11:02:19

hows it going?

Tak for hjælper - det fungerer bare.
Det eneste jeg skulle rette, var opbygning alle relationer til den nye tabel, så den igen ligner den oprindelige tabel.

great, I dont know if you have accepeted the answer, I think there is a problem at the moment. Eksperten doesnt seem to want to accept!

.

Tak