如何跟踪“不能找到对象”复制数据库和在Access中查看错误？ [英] How to track down "can't find the object" errors copying databases and viewing in Access?
问题描述
（这看起来不像一个编程问题，但它可能归结为一个编程问题。）
(This doesn't look like a programming question but it might boil down to a programming question.)
我使用MS Access 2007来查看表
I'm using MS Access 2007 to view tables in a database (through an *.adp file) that lies on SQL Server 2000 and SQL Server 2005.
我使用MS SQL Server Management Studio中的复制数据库任务来复制数据库（通过* .adp文件），它位于SQL Server 2000和SQL Server 2005上。数据从SQL Server 2000（live服务器）到SQL Server 2005（在我的本地计算机上）。副本似乎已成功执行。
I use the Copy Database task in MS SQL Server Management Studio to copy the data from SQL Server 2000 (the "live" server) to SQL Server 2005 (on my local computer). The copy appears to execute successfully.
我有两个单独的* .adp文件。一个链接到活动服务器上的数据库，另一个链接到本地计算机上复制的数据库。
I have two separate *.adp files. One links to the DB on the live server and the other to the copied DB on my local machine.
我可以使用我的本地数据库上的大多数表机器罚款，但其中一些导致Access抛出此错误，我甚至可以看到数据或设计视图之前：
I can work with most of the tables on the DB on my local machine fine, but a few of them result in Access throwing this error before I can even see the data or the design view:
Microsoft Office Access找不到对象'SELECT *，sql _ variant _属性（值，'basetype'）AS类型FROM :: fn_ listextendedproperty（N'MS _ DisplayViewsOnSharePointSite'，N'user'，N'dbo' ，N'table'，N'tbl_Asset'，NULL，NULL）'。
- 您拼写错误的对象名称。检查是否缺少下划线（_）或其他标点符号，并确保未输入前导空格。
- 您尝试打开链接表，但包含该表的文件不是在您指定的路径。使用链接表管理器更新链接并指向正确的路径。
这个错误在五个表上，唯一的变化是tbl_Asset被替换为冒犯的表名。）
(I have this error on five tables, and the only thing that changes is that "tbl_Asset" is replaced with the offending table name.)
我没有同样的问题，我使用Access来查看活动数据库上的表。此外，当我通过SQL Server Management Studio查看本地数据库上的表时，我没有此问题。
I don't have the same problem when I use Access to view the tables on the live DB. Also, I don't have this problem when I view the tables on the local DB through SQL Server Management Studio.
无论如何，我没有线索从哪里开始查找。我不认为错误消息下面的两个建议适用。
Anyway, I have no clue where to start looking. I don't think the two suggestions beneath the error message apply.
有任何建议吗？感谢您的帮助。
Any suggestions? Thanks for your help.
更新：发现我认为的原因，但仍然无法解决。我会在下面发布我的进度。感谢
UPDATE: Found what I think is the cause, but still can't resolve it. I'll post my progress below. Thanks
推荐答案
当从SSMS脚本化CREATE时，它将默认包括扩展属性。您需要在重新创建表格之前手动删除这些表格。
When scripting the CREATE from SSMS it will by default include the Extended properties. You'll need to remove these by hand before re-creating the table.
这篇关于如何跟踪“不能找到对象”复制数据库和在Access中查看错误？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
