Autonumber propagating through make table query

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.
 
V

Van T. Dinh

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.
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber and Make Table Query 1
Make Table Query and Autonumber Fields 6
Append query - Append to table with Autonumber field 2
Trouble with Query Results 11
Update the values in a table from another table 1
Make-table query and multiple autonumber fields 6
Links in Query results 3
Make table query: [Enter 1] AS Test 1

Top