Pivot tables in MS Access 2007

[Roxanne Neagu]

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"

[pdebaets]

This info may help: http://support.microsoft.com/kb/269495

[Roxanne Neagu]

Pivot tables in MS Access 2007

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!

[Rabbit]

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.

[NeoPa]

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.

[Rabbit]

That registry key won't work fix it anyways, I tried it yesterday.

[NeoPa]

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.

[Rabbit]

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.

[NeoPa]

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.

[Rabbit]

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.

[NeoPa]

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.