Access Access 2007 DB reaching 2GB limit and Transform query

S

snoopy12

Joined
Jul 19, 2011
Messages
2
Reaction score
0
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.

Thanks!
 

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

Similar Threads

Access #Error & Excel Pivot 0
Access MS Access 2007 split database 1
Access stripping decimal places in query 1
linking to SQL Server db table 6
Access Issue, Macro Single Step, Error 3270 0
Excel 2000 QueryTable to MSAccess SQL with "TRANSFORM" 1
Access Access Daisy Chain Linked Tables 0
Crosstab Query Header Fields (?) 3

Top