Make Table Query

  • Thread starter Thread starter Tim
  • Start date Start date
Hi, how do I add a Primary Key ID number at the start of a
Make Table query ?

Tim
Click to expand...

You can't. You'll need to create the table and then use DDE code to
add the field, or (better) create the table empty, first, and then use
an Append query rather than a make-table.

Note that make-table queries are VERY RARELY really necessary. They
are slow, they are inefficient, they cause rapid database bloating (if
you create a table and then delete it the space is not recovered); and
if all you want to do is create a Form, a Report, an export, or
another query, you can simply use a Select query.
 
Back
Top