Strip field of AutoNumber

  • Thread starter Thread starter Ed Kopta
  • Start date Start date
E

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?
 
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?
Click to expand...

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

NewID: Val([MyAutonumberFieldName])
 
Back
Top