MS Access 2007中的数据透视表 [英] Pivot tables in MS Access 2007

问题描述

嗨

我正在尝试在MS Access 2007中创建一个数据透视表。我尝试使用Pivot Tavle View打开查询，但是我收到此错误：


多步OLE DB操作生成错误。检查每个OLE DB状态值（如果可用）。没有完成任何工作"

解决方案

此信息可能有所帮助： http://support.microsoft.com/kb/269495

谢谢，但不，它没有帮助。实际上，我从家里登录到我的工作计算机，我打开了我遇到问题的确切Access应用程序，当我在家里尝试Pivot Table View时，它的工作原理！

我回来工作，但它没有用。所以它必须是一些设置问题...一些冲突...


提前谢谢！

我遇到了完全相同的问题昨天。我运行了Microsoft Office Diagnostics并修复了任何搞砸的配置。您可以通过单击微软按钮>找到它。访问选项>资源>诊断

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"

解决方案

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

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!

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.

这篇关于MS Access 2007中的数据透视表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！