收到错误：Microsoft Access数据库找不到对象“表XYZ”。对于发布到SharePoint的Access数据库 [英] Error Received: Microsoft Access database could not find the object "Table XYZ" for an Access Database published to SharePoint

问题描述

我有一张桌子"XYZ"有38列，其中30列是查阅列（1个查找/与另一个现有表关系; 29个查找列，其值为手动设置）和8 是/否字段。  

I have a table "XYZ" with 38 columns, 30 of which are lookup columns (1 lookup/relational to another existing table; 29 lookup columns with values manually setup) and 8 Yes/No fields.  

表已成功通过Access Services发布到SharePoint网站，但是，我无法在Access数据库中打开它。字段的数量/类型是否存在问题？如果是这样，在使用已发布的数据库时，是否有任何明确指定ALL（我的意思是全部）
限制的内容。  我知道有40列是表格在网络数据库中工作的限制 所以我试图限制表格中的内容，以避免任何问题。我也知道在表格中可以使用的查找列数量有一个限制
，但我认为这是52（已经/那样做了，并且收到的错误明确表明表格超过了数字列允许）。

the Table was published to the SharePoint site through Access Services successfully, however, I can't opened it in the Access Database. Is there an issue with the number/type of fields? If so, is there anything that clearly specifies ALL (an I mean all) of the limitations when working with published databases.  I know that 40 columns is the limitation for forms to work in the web database so I tried to limit that in the table as well to avoid any issues. I also know that there is a limitation on the number of lookup columns that can be used in the table but I thought that was 52 (been there/done that and the error received clearly states that the table exceeded the number of columns allowed).

感谢您的帮助。

belinda martinez

belinda martinez

推荐答案

推测我认为你可能已经超过了一个表可以拥有的32个索引。

Speculating I think you may have exceeded the 32 indexes one table can have.

我不知道资源有多种限制。这是一个机会。

I don't know of a resource with all limitations. Here is an opportunity for you.

这篇关于收到错误：Microsoft Access数据库找不到对象“表XYZ”。对于发布到SharePoint的Access数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！