Save a query with 33millions rows without invalid argument

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
If the size of the database expands beyond 2 gb the "Invalid Argument
Message will display" Check the size of the database.
 
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.
 
Back
Top