Why do I get "invalid arguement" when using make table query?

[NikkI]

I have a database I built for a project at work and the main table is over
500,000 lines, I am trying to make queries by using the make table query and
every time I hit the run key it gives me the invalid arguement message.

I have tried using existing queries and creating new queries and neither one
will work. I have also checked the files to make sure there is no misplaced
data or anything of that sort and I can't find anything that would not let me
make a table.

 

[David Pawloski]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

David Pawloski
Microsoft MVP

 

[John Vinson]

I have a database I built for a project at work and the main table is over
500,000 lines, I am trying to make queries by using the make table query and
every time I hit the run key it gives me the invalid arguement message.

Why would you WANT to use a MakeTable query!? If it's unrestricted,
you'll be creating a (presumably totally redundant) new 500000 row
table. There is VERY little that you can do with a new table which
cannot be done with a simple select query.

I have tried using existing queries and creating new queries and neither one
will work. I have also checked the files to make sure there is no misplaced
data or anything of that sort and I can't find anything that would not let me
make a table.

How big is the database on disk? If it's approaching the 2GByte limit
you'll get wierd errors. Try Tools... Database Utilities... Compact
and Repair.

If you wish, please feel free to post the SQL of the query; maybe
someone can spot the illegal argument (if there is one).

John W. Vinson[MVP]

 

[Jeff Boyce]

Disregard the "you can't do this" response. It is either SPAM or something
worse. Follow the link at your own peril!

The person posting the response has used several different aliases, and is
now representing him/herself as an MVP.

Regards

Jeff Boyce
Microsoft Office/Access MVP