Save a query with 33millions rows without invalid argument

[Guest]

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.

 

[Keith Leslein]

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

 

[Guest]

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.