MS Access CrossTab Query / Size Limit Problem
Posted on 2007-03-19
Access 2000 with XP: (Will be getting Vista and Office 2007 soon)
I have an Access database with 3 tables that are joined in a query. Each table at this time has bunches of records and lots will be added everyday. When linked together to run a Crosstab Query, it seems to go past the 2 GB size that Access allows and will not open.
My question is which application is the next step up that can do Crosstab Querys from another query with about 100,000,000,000,000 records and is there a size limit OR can code be written in Access that will let me get the Top 100 Results from the Crosstab query without it taking forever and 2 days?
How to do this will come in later questions.
This will be awarded to the first to repsond.