Autonumber and Make Table Query

G

Guest

I am using Access 2000 and have a Make Table query that delivers the results
of joining several tables so that I can manipulate the results without
affecting the original data. One of the fields in one of the tables is set to
Autonumber.
I want to modify this field in the resultant table, but I have found that
Access has set the field in the new table to Autonumber, despite the
documentation saying field attributes are not propagated through a make table
query. Is there a way of stopping this happening? At the moment the only
thing I can think of doing is to use DDL to modify the field attributes of
the table after running the query.
 
J

John Spencer (MVP)

1) Autonumber is a field type just like date is a field type and currency is a
field type.

2) One method if your structure is static would be to build the table once, and
then clear it out with a delete statement and then append the records instead of
using a make table query.

Other than that you will have to use code (DDL or VBA) to modify the table
structure after it is created.
 

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

Top