Trying to run a query on a large data set

Hi everyone,

I am attempting to run a query on approx. 5 million static records. When I run the query I get an error that says database has reached maximum size. So I tried compacting/repairing. I then opend a new database and linked the table in, and when I ran the query I got the same results. Any thoughts?

The query is nothing out of the ordinary, and I can query other smaller tables without a problem.

re: Trying to run a query on a large data set

You've maxed out the capabilities of Access, you'll need to upgrade or break your tables into smaller pieces.