将 Access 数据库与 SharePoint 结合使用时遇到了哪些类型的问题？
只是好奇将 MS Access 表上传到 SharePoint 2007 列表的体验如何。我们一直在计划这样做，但我似乎记得 SharePoint 损坏结果列表中的 Access 表的问题，而且通常迁移进展得不太顺利。你的经历？最佳实践和建议？我特别关心它迁移表单和报告的能力（如果可以的话）。谢谢！
Just curious what the experience has been in uploading MS Access tables to SharePoint 2007 list. We've been planning on doing so, but I seem to recall issues with SharePoint mangling Access tables in the resulting lists and generally the migrations not going so well. Your experiences? Best practices and recommendations? I'm particularly concerned on its ability to migrate forms and reports as well if it can do so. Thanks!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
为了回答英国 SharePoint 用户组的问题，我在 将 Access 2007 与 SharePoint 列表结合使用，您可能会对此感兴趣（也有一些有趣的评论）。
Access 2007/SharePoint 2007 中没有迁移表单或报表的工具，只有表。 Access 2010/SharePoint 2010 中的许多新功能允许您为 SharePoint 创建 Access Web 数据库。
德里克
In response to a question from UK SharePoint User Group I wrote a blog post on Using Access 2007 with SharePoint lists which you might find interesting (some interesting comments too).
There is no facility to migrate forms or reports in Access 2007/SharePoint 2007, only tables. Lots of new stuff in Access 2010/SharePoint 2010 which will allow you to create Access Web databases for SharePoint.
Derek
如前所述，Access 2010 的重大新闻是我们可以构建网站并将应用程序发布到网络。这是我在浏览器中运行 ms-access 的视频（第一部分在客户端中，但您可以清楚地看到我在视频的 ½ 处切换到应用程序的浏览器版本）：
www.members.shaw.ca/MrTurtle/2010d1/w1.html
对于 access 2010，表（或所谓的列表）将具有级联删除、级联删除限制等功能。还有一大堆性能改进，将允许更大的列表尺寸表现良好。
请注意，当您发布数据库时，新表触发器（数据宏）也将上传到 SharePoint。
对于 Access 2007，实际上并没有任何特别的问题，但与即将推出的下一版本的 Access 相比，存在更多限制。因此，例如，如果您需要链接 2007 年拥有的一大堆相关表，当您将表推送到共享点时，您将没有任何级联删除或任何 RI 选项，就像您在 access 2010 中所拥有的那样。
因此，我不建议使用一大堆相互关联的表来推动应用程序。它就是行不通。但是，如果您有一个简单的客户列表或需要共享的数千个姓名的联系人列表，那么 access 2007 应该适合您。
因此，请记住，如果您有需要共享的列表或表格，那就没问题了。但是，如果您有一大堆相互关联的表，并且您需要以这种方式运行应用程序，那么您将不会有任何运气或成功。
As mentioned, the big news for Access 2010 is we can build web sites and publish applications to the web. Here is a video of me running ms-access in a browser (the 1st part is in the client, but you clearly see me switch to the browser version of the application about ½ into the video):
www.members.shaw.ca/MrTurtle/2010d1/w1.html
For access 2010 the tables (or so called lists) are going to have things like cascade deletes, cascade delete restrict. There also again a whole bunch of performance improvements that will allow much larger list sizes to perform well.
Note that the new table triggers (data macros) will also go up to SharePoint when you publish the database.
For access 2007, there is not really any particular special problems, but there is just more limitations compared to the next version of access that is coming out. So for example if you need to link up a whole bunch of related tables you have in 2007, when you push the tables up to sharepoint, you don’t have any cascade deletes or any RI options like you’ll have in access 2010.
So I don’t recommend pushing up an application with a whole bunch of interrelated tables. It just not going to work. However, if you have a simple customer list or contact list of a few thousand names that you need to share, then access 2007 should work just fine for you.
So, keep in mind if you have a list or table you need to share, then fine. However, you not going to have any luck or success if you have a whole bunch of tables that are interrelated, and you need to run the application in that fashion.