Make Table Query problem

[Eric]

I'm an Access newbie so any help is appreciated. I have a
database that has to run several make table queries.
However, one of those queries did not run and spit back
out an error message that stated "Invalid Argument."
Clicking on the help button it pointed me toward Error
3001....which did nothing to help. The problem is that
all of my other make table queries that were running fine
before no longer work and give me the same "Invalid
Argument" message. The weird thing is that when I change
the query to a Select query. It runs fine and give me my
results. I had other people run the same database on
their machines and they had the same results. They
received the invalid argument message when they did the
Make table query and received the correct results from the
Select query. This has happened several time now and is
very frustrating. Does anyone have any suggestions?
Thanks.

 

[Guest]

ARe you running this from a macro?

 

[John Vinson]

I'm an Access newbie so any help is appreciated. I have a
database that has to run several make table queries.

Are you quite certain that you *have* to run MakeTable queries? In my
experience it's really a rather rare requirement. Bear in mind that
you do NOT need to create a Table to generate a report, or a form, or
an export - all of these can be done from a Select Query.

However, one of those queries did not run and spit back
out an error message that stated "Invalid Argument."
Clicking on the help button it pointed me toward Error
3001....which did nothing to help.

Please post the SQL of the query. Are you deleting the previously
created table before re-running the MakeTable?