Problem with Make Table Query - Resultant Table not allowed to have more than one AutoNumber field.

N

Neil Robbins

I'm trying to write a MakeTable query that will bring together data from a
number of tables and export it as a single table to another database.
Unfortunately when I run this query I get the following error "Resultant
Table not allowed to have more than one AutoNumber field."

Does anyone know a way of changing the Data Type of an autonumber field to a
compatible data type within a make table query.

Any help is always appreciated.

Neil R.
 
N

Neil Robbins

Just realised that I posted this to the wrong group. I have reposted to
access.queries.

Apologies
 

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

Problem with Make Table Query - Resultant Table not allowed to have more than one AutoNumber field. 5
Make-table issue 2
Append query - Append to table with Autonumber field 2
Make table with AutoNumber fields 4
Resultant table not allowed to have more than one AutoNumber Field 3
Autonumber and Make Table Query 1
Make-table query and multiple autonumber fields 6
Add autonumber with Make Table query 3

Top