jtgraphic
asked on
Inserting Value for Auto Incremement in MS Access 2002
I need to insert three records (including auto-increment) from an older database into a newer one that is exactly the same.
Use an Append query without including the Autonumber field. The Autonumber field in the newer database will be automatically incremented.
ASKER
That's what I DON'T want to happen. I have record 45678, 45679, and 456780, but the next increment is 87654. Every time I insert them, it increments in the 80k range. I'd like them to insert as their original key. For the record. The "new" database starts around 50k, so there wouldn't be a key overlap.
-JKT
-JKT
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The two tables are both called "orders". I tried exporting the records, but don't know how it import and retain the original key. It just keeps appending it to the end. Is it possible that it's a constraint somewhere in the database design?
Did you import it with the key field?
Did it ignore the key field and increment the Autonumber?
Did it ignore the key field and increment the Autonumber?