ODBC Microsoft Access Driver Login Failed

I

IgorM

Further to my previous post I decided to describe more precisely the problem
I have. I created an OLAP cube in Excel 2003 with data from an Access 2003
mdb database file. Then, I created a pivottable with the cube.
Unfortunately, I had to move the database mdb file to different location.
Now, when I click refresh in the pivottable a get an error: ODBC Microsoft
Access Driver Login Failed. When I click ok in the message box with the
error I can then navigate to the database; data/cube is refreshed. I noticed
that I can do this only once per session though. When I click refresh for
the second time I get a message that query could not be run. But when I
reopen the file, navigate to database, as described above, it gets
refreshed.
So, is it possible to edit the path for the cube permanently.

Kind regards
IgorM
 

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

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Local cube path to database 1
Pivot table on local cube 1
ODBC Microsoft Access Driver Login Failed 1
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Cube errors 0
Changing OLAP Pivot Table Connection Source 0
cub and/or oqy files in 2007 0

Top