Analysis Services Access Database

Hello,

I am trying to generate a cube in SSAS 2005 with an Access database as the data source. I can create the Data Source and successfully test the connection. Here is my connection string:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\DB\LSAM.mdb

I can also successfully create my Data Source View and I can return data by right clicking on any of my table objects and selecting 'Explore Data'

However, when I try to generate my cube, I receive the following error message:

OLE DB error: OLE DB or ODBC error: 'E:\DB\LSAM.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.; 3044.

Any assistance would be GREATLY appreciated.

Thank You,

Joshua Shull.

Try and import your Access database into SQL Server and build your cube from there.

Later you can try and change datasource to point to the access file and process it .

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.