Autonumber propagating through make table query

  • Thread starter Thread starter Jeremy Saul
  • Start date Start date
J

Jeremy Saul

I have a make table query in Access 2000 where one of the tables has an
autonumber field. After running the query I find that the corresponding
field in the new table is also autonumber, even though the Access
documentation states that field attributes are not copied in a make table
query.

Any ideas why this is happening and how to overcome it?

Thanks.
 
I rarely use Make-Tabke Queries ...

My method is to always set up the Table with the Structure / Field types I
want and then use the Append Query.

This can be used as the work-around for you.
 
Thanks, I'll try that.

Van T. Dinh said:
I rarely use Make-Tabke Queries ...

My method is to always set up the Table with the Structure / Field types I
want and then use the Append Query.

This can be used as the work-around for you.
Click to expand...
 
Back
Top