Number 2 is the best option to do.

I don't have a solution but you can check if the problem is related to MS office or SQL server.

Use a external SQL client and use the same ODBC connection...

I'm not following you completly but you can't have a measure in one facttable with a different rollupstate. Normally I create a different facttable for every rolluplevel. When measures have...

This a example for VS 2005 in C#, maybe this will resolve your issu.

Cursor.Current = Cursors.WaitCursor;

fclsReport frmReport = new fclsReport();

frmReport.NewFormString = m_IncidentID;

frmReport.GMSOmgeving = GMSOmgeving;

frmReport.EmailAdres = EmailAdres;

frmReport.PDFLocatie = PDFLocatie;

frmReport.SluitRapportEmail = SluitRapportEmail;

frmReport.Show();

frmReport.WindowState...

Increase the amount of memory for the DB (properties on the server) en run the command to shrink the Database to make sure that your log file is clean en...

When I read the MS documents you should say that you can change the memory, but default SQL Server will ajust the memory by him self.

http://msdn2.microsoft.com/en-us/library/ms175123.aspx

http://msdn2.microsoft.com/en-us/library/ms180967.aspx