Make-Table Query problem

[MikeAngelastro]

Hi,

A client of mine is using Access 2002. I haven't used Access 2002 until now. I am having a problem that I have never had before. I am trying write a make-table query that links tables containing autonumber fields. Running it in datasheet mode is not a problem. When I try to run it as a make table query, I get error message "Only one autonumber field allowed in the table." Access then refuses to save the table.

Any ideas?

Mike

 

[llkhoutx]

The message is exactly right. Only one autonumber field per table.

If you really need multiple ones, create long data fields to hold the appended autonumbers.

 

[Pat Hartman]

I have run in to this also. You're not nuts, the behaviour has changed from earlier versions. I think I solved it by using the Format() function to turn the autonumbers into strings.