Save a query with 33millions rows without invalid argument

S

Sanjay

i am building a qquery in design view in Access which creates 33millions
rows. When i try and save the query it says "invalid argument". I don't know
why.
 
K

Keith Leslein

If the size of the database expands beyond 2 gb the "Invalid Argument
Message will display" Check the size of the database.
 
J

Jerry Whittle

What Keith said.

Also 33 million records returned? Assuming multiple tables, are they all
joined in the QBE window with a line between them? Preferably from primary
key to foreign key? I'm thinking that you have a Cartesian join creating a
lot of bogus, repeated data.

If you really need 33 million records, Access might not be the right tool
for the job.
 
Top