Strip field of AutoNumber

[Ed Kopta]

I am using a Make-Table query to create a temporary table from another
table. Problems arise with the AutoNumber field: I need the data in it but I
do not want that to be an AutoNumber field in the temp table (just Long).
I've tried messing with the Field.Attributes property after the temp table
is created, but that just generates an error.

Is there an elegant way to modify the Make-Table query to strip the
AutoNumber field of its AutoNumberness?

 

[Bruce M. Thompson]

I am using a Make-Table query to create a temporary table from another

table. Problems arise with the AutoNumber field: I need the data in it but I
do not want that to be an AutoNumber field in the temp table (just Long).
I've tried messing with the Field.Attributes property after the temp table
is created, but that just generates an error.

Is there an elegant way to modify the Make-Table query to strip the
AutoNumber field of its AutoNumberness?

In your make-table query, give your autonumber field an "alias" containing only
the *value* of the autonumber field:

NewID: Val([MyAutonumberFieldName])

 

[Allen Browne]

Create the table with the fields as you wish, and then use an Append query.