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