469,091 Members | 1,154 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,091 developers. It's quick & easy.

Pivot tables in MS Access 2007

Hi
I am trying to create a pivot table in MS Access 2007. I try to open the query using Pivot Tavle View, but I get this error:

"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done"
Nov 25 '11 #1
10 4237
This info may help: http://support.microsoft.com/kb/269495
Nov 25 '11 #2
Thanks, but no, it didn't help. Actually, I logged on from home to my work computer, I opened the exact Access application that I have problems with, and when I try Pivot Table View from home, IT WORKS !
I come back to work, and it's not working. So it must be some set-up issue...some conflict...

Thanks in advance!
Dec 1 '11 #3
Rabbit
12,516 Expert Mod 8TB
I had the exact same problem yesterday. I ran the Microsoft Office Diagnostics and it fixed whatever configuration was messed up. You can find it by clicking the microsoft button > access options > resources > diagnose.
Dec 1 '11 #4
NeoPa
32,159 Expert Mod 16PB
Roxeanne:
I come back to work, and it's not working. So it must be some set-up issue...some conflict...
Indeed. Probably the something covered in the linked article I would say. Did you try setting the Registry value as indicated in the article? Did you even read the article (I ask as your response tends to indicate otherwise)?

PS. I cross-posted with Rabbit. I would suggest that approach first as it's much easier and, if it works for you, saves you the extra hassle.
Dec 1 '11 #5
Rabbit
12,516 Expert Mod 8TB
That registry key won't work fix it anyways, I tried it yesterday.
Dec 1 '11 #6
NeoPa
32,159 Expert Mod 16PB
Possibly not Rabbit, but can you be sure you were experiencing exactly the same situation as the OP?

If it were me I'd certainly check it out thoroughly for myself if your easier method didn't work.
Dec 1 '11 #7
Rabbit
12,516 Expert Mod 8TB
I'm fairly certain. That CLSID is for SQL Server. OLAP in Microsoft Access uses a different driver, I was unable to find out which one, and in turn, find its corresponding CLSID to test the registry key. Besides, the OP said the article didn't resolve their problem.
Dec 1 '11 #8
NeoPa
32,159 Expert Mod 16PB
Rabbit:
Besides, the OP said the article didn't resolve their problem.
If they'd explained that they'd tried it out, or even explained what they'd tried, I'd give credence to that, but as it stands I see no reason to. Not that it matters at this stage, as I expect you're suggestion will work anyway. I'm just not ready to assume so at this point.
Dec 1 '11 #9
Rabbit
12,516 Expert Mod 8TB
Well, they did say
Thanks, but no, it didn't help.
I took that to mean they looked at the article and attempted to resolve it using the suggestions in the article.
Dec 1 '11 #10
NeoPa
32,159 Expert Mod 16PB
And you may well be right to. Perhaps I'm a little less trusting than you, but then I've had a number of occasions very similar to this where it turned out that if the OP had looked properly they would have found their answer right then, and it was only after explaining exactly the same to them again later in the thread that they appreciated it for what it was.

I have no concrete reason to suspect that in this case, but I see no need to wait and see as the steps to follow are exactly the same in both cases.
Dec 1 '11 #11

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Prasad Patil | last post: by
1 post views Thread by Clive Moss | last post: by
4 posts views Thread by Del | last post: by
1 post views Thread by Jerome Ranch | last post: by
3 posts views Thread by nikila | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.