Access Access 2007 DB reaching 2GB limit and Transform query

Jul 19, 2011
Reaction score
Hi All,

My Access DB is around 1.9GB now, and there is only 1 big table which makes up most of the 1.9GB. We do have SQL Server at work, only issue is that the queries that run on this table are Transform ... Pivot queries and these do not work in SQL Server.

I thought perhaps I could split this table into multiple Access DBs but not sure how to link it all back together? Has anyone done this, or is there another method. The result of the queries are cut and paste into Excel, and these have already been set up to work with the data in the pivot format.



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question