"Invalid Argument" with make-table

[Crevalle]

When I attempt to run a make-table query, I get this message. I read that it may be due to overly large tables?

The make-table query I am running should create around 200,000 rows, so this may be the issue???

I appear to have the newest update packs. I attempted to compact the database, but it's been running for over 30 minutes, and task manager says it is not responding.

Any ideas on what may be causing this?

 

[dhookom]

The "not responding" may not be true. What is the source of the make table query? Are there multiple tables in the source? If so, are the joined fields indexed? Are you running this on a local machine or across a network?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Crevalle]

dhookom--To answer your questions:

There is just one table in the make-table query

I was running it across a network. I am currently in the process of copying the database to my desktop, where I will give it another shot. Do you think this is feasible?

 

[dhookom]

Are you setting any criteria in your make table query? Would you care to share the SQL view? Running it locally should improve the speed.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.