Maketable query with Autonumber column

[Guest]

I am working with a legacy database that contains a large table (5M records)
which has multi-column primary key. What I want to do is write a query that
will extract a subset of the records from this table and write the records to
a table in a local (temporary mdb) that sits on the users PC. But as part of
this query, I would like to add an autonumber field, to make referencing each
record easier. I know I can run the maketable, then use AlterTable to modify
add the autonumber field, but is there a way to do this within the query, and
not have to go through the additional steps of the AlterTable?

 

[JohnFol]

Another way to do it is to create a dummy table on the local mdb, that
includes the autonumber and fields you use in the Create Table. Then you do
a delete * from dummy table, followed by an Append query

Someone else might know an alternative . . .