I get this when trying to create a table (one time, then I will delete
and populate) from a query.

I have seen good answer to this if my query includes autonumber fields
but my query does not contain ANY autonumber fields. I can't understand
why I'm still getting this error.

Any ideas?

Joel

Do you mind sharing your SQL view of your query as well as the field data
types?

--
Duane Hookom
MS Access MVP


"Joel" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I get this when trying to create a table (one time, then I will delete
> and populate) from a query.
>
> I have seen good answer to this if my query includes autonumber fields
> but my query does not contain ANY autonumber fields. I can't understand
> why I'm still getting this error.
>
> Any ideas?
>
> Joel
>

Ok I feel dumb. There were indeed autonumber fields. Put me on your "ignore"
list now :-)

Joel

Duane Hookom wrote:
>Do you mind sharing your SQL view of your query as well as the field data
>types?
>
>>I get this when trying to create a table (one time, then I will delete
>> and populate) from a query.
>[quoted text clipped - 6 lines]
>>
>> Joel

"Here's your sign" ;-)

--
Duane Hookom
MS Access MVP


"Joel E via AccessMonster.com" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Ok I feel dumb. There were indeed autonumber fields. Put me on your
> "ignore"
> list now :-)
>
> Joel
>
> Duane Hookom wrote:
>>Do you mind sharing your SQL view of your query as well as the field data
>>types?
>>
>>>I get this when trying to create a table (one time, then I will delete
>>> and populate) from a query.
>>[quoted text clipped - 6 lines]
>>>
>>> Joel