Copying table with Autonumber field

P

Peter Kinsman

I am copying a database in which a number of tables have Autonumber fields
as their Primary Index, which are used in Bill of Material structures. Some
of the new tables have extra fields.
I was going to use DAO to create the new tables, using lookup tables to link
the Record_ID in the old table to the Record _ID in the new table, but I
find that if I use SQL to create the new table, the values of the Autonumber
fields are preserved.
Does anyone know whether this is a fluke or it should work this way please?

I am using Access 2003

Many thanks

Peter Kinsman
 
P

Peter Kinsman

I have done some further investigation and it would appear that if the new
table has an extra field and the SQL statement is of the form
INSERT INTO...SELECT * FROM
then field mapping is carried out automatically.

Again, does anyone know if this is how it should be please?

Thanks

Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber records inserted in gaps 1
Populating an autonumber field 2
Work tables in multi-user database 2
Use vba to change table design 2
Make table with AutoNumber fields 4
VBA - retrieve data on last create named range from previous inserted named range 0
Generate a new backend 2
Access Sequentially numbered column that resets with each new sample 0

Top