Make-table issue

[Tara]

I have a make-table query using two tables that each have primary keys that I
need to have in the resulting table. The query gives me the message
"Resultant table not allowed to have more than one Auto Number field". Is
there an easy way around this?

Thanks!

 

[John W. Vinson]

I have a make-table query using two tables that each have primary keys that I
need to have in the resulting table. The query gives me the message
"Resultant table not allowed to have more than one Auto Number field". Is
there an easy way around this?

Thanks!

The first question I'd ask is... "Do I need a MakeTable query AT ALL?"

MakeTable queries can be useful - once - in the initial setting up of a
database from existing data. They would be very, very rare in a working
production application. There's very little that you can do with a new table
which cannot be done with a Select Query (the one upon which your MakeTable
query is based).

What are these three tables? Why do you feel you need a new one? Could you
post the SQL of the MakeTable query?

 

[Armen Stein]

MakeTable queries can be useful - once - in the initial setting up of a
database from existing data. They would be very, very rare in a working
production application. There's very little that you can do with a new table
which cannot be done with a Select Query (the one upon which your MakeTable
query is based).

Agreed. And even if you really do need data duplicated in another
table, it's better to keep a persistent table, and delete all the
records and append them back in, instead of using a MakeTable.

The benefits are 1) consistent table structure and 2) less database
bloat and corruption risk.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com