Change base of AutoNumber?

[pungentSapling]

**RESOLVED**Change base of AutoNumber?

My data base table uses an auto number as primary key and this number is essential for tracking records.

There are several instances of the db running in parralel...all that save to a linked table via an append query.

A code letter is concatenated onto the number just before the append query moves all the enteries to a linked table. This allows me to keep track of who made the entry. (It is not an autonumber in the linked table).

problem is that I want to release a new version of the db and I dont want to end up with duplicate numbers....Is there a way that I can make autonumber start from a specific number.ie:where it left off in the previous version.

 

[ColinEssex]

If you look in Access help - it tells you how to do it there step by step - look up AutoNumber, start value and increment.

Col

 

[pungentSapling]

had to re-install help files


thanks!
not an overly simple proccess though.

 

[ColinEssex]

Thats why I thought it would be better for you to print it off and work through it rather have me explain it here!!

It does work though - good luck

Col