N
NOTdbRanger
Access 2003 Help files tell me this regarding a make-table query:
"Note The data in the new table you create does not inherit the field
properties or the primary key setting from the original table."
However, in Access 2007 I created a make-table query that picks up the
primary keys from two different tables and upon execution I get an error
message that says (paraphrased) "Cannot have multiple primary keys in the new
table".
Did '07 Access change? Is there a work-around--perhaps a property I can
disable?
"Note The data in the new table you create does not inherit the field
properties or the primary key setting from the original table."
However, in Access 2007 I created a make-table query that picks up the
primary keys from two different tables and upon execution I get an error
message that says (paraphrased) "Cannot have multiple primary keys in the new
table".
Did '07 Access change? Is there a work-around--perhaps a property I can
disable?