make table query and "invalid argument"

[Dave Kaplan]

In Access 2002 I used the make table query to make a table and had no

problems. I wanted to repeat the query with the same original table

and got an INVALID ARGUMENT error. Nothing changed in the query or

table between the two attempts. What would cause Access to make a

table once and then run into an error when I repeat the make table?

 

[Chris]

Did you delete the table before running the query the
second time???

 

[Dave Kaplan]

Thanks for the response, but no -- the tables were still there. I know I
checked to make sure there was nothing wrong with them. What happened is
that the make table query is fine when it operates as a select table. The
problem INVALID ARGUMENT appears when I try to make it into a table.

 

[Chris]

I must have misread your initial message.
I thought that the problem was that the first time you ran
the query it created the table correctly. The second time
you ran the query, it produced the error.

Running the query the second time will produce an error if
the table you are trying to create already exists.

If you have a good reason for re-running the make table
query frequently, you will need to ensure that the
previous creation has been deleted.

 

[Dave Kaplan]

Chris --

And I must have misread your question as well, for which I apologize. let me
re-state.

The problems is that the first time I attempted a make table query from a
"source" table it worked -- i.e. source table [TBL1999] produced
[MKTBL1999]. But the second (and subsequent times) it failed, with very
similar tables. So, I could not use source table [TBL2000] to make
[MKTBL2000]. TBL1999 and TBL2000 were exactly alike except for the data.
Subsequent attempts failed as well, with similar tables.

I did not know if this is a peculiar glitch, or something that has to do
with my source tables. I have looked over them, and have not found any red
flags.