Append Query - Invalid Argument message

J

jande30

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 :)
 
S

ShaneDevenshire

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.
 
J

jande30

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.
 
S

scmwiz

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
 
P

Pieter Wijnen

Posting some SQL might be helpful

Pieter

scmwiz said:
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
Click to expand...
 
S

ShaneDevenshire

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?
 
Top