Append Query - Invalid Argument message

[Guest]

I am trying to run append queries to join 8 tables. I was able to run the
query one time, however, each time after I receive the following message:

"Invaid Argument"

All of my tables are identical...any help would be great!

Thanks

 

[Guest]

Hi,

Not enough info to answer, however, this could be because there are
duplicate primary key values in the tables - that is the target table and the
source table.

 

[Guest]

I do not have any primary keys set. What kind of information do you need. I
am new at this and do not know what type of information you need.

Thanks.

 

[Guest]

Jande30 / Shane

I too have exactly the same problem...i am trying to append data in table A
to table B ( both tables are identical in structure and have no primary key ).

However I am getting the error message ( INVALID ARGUMENT ) ....

plz any suggestions ?

rgds
SCM FREAK

 

[Pieter Wijnen]

Posting some SQL might be helpful

Pieter

Jande30 / Shane

I too have exactly the same problem...i am trying to append data in table
A
to table B ( both tables are identical in structure and have no primary
key ).

However I am getting the error message ( INVALID ARGUMENT ) ....

plz any suggestions ?

rgds
SCM FREAK

 

[Guest]

Hi,

Are you doing this with VBA or SQL or just on the query grid? If you have
criteria what are they an under what field?