链接表问题与Access 2007中的无效名称 [英] Link Table problem with invalid name in Access 2007

问题描述

大家好，


有没有人解决过链接表的问题？我使用Access 2003工作时数据库正常工作，但是当我的PC升级到使用Access 2007时，我无法通过链接表管理器看到表列表，当我尝试删除链接表时，它弹出一个错误消息说：

''''不是有效名称。确保它不包含无效字符或标点符号，并且不会太长。


数据库可以从同一个后端数据库导入链接表，但是这些表被重命名而不是替换旧表。我该如何解决这个问题？谢谢


Colin

Hi guys,

Is there anyone who had and resolved a problem with linked tables? The database works normally while I do the work with Access 2003, but when my PC had upgrade to use Access 2007, I cannot see the table list through the Link Table Manager, and when I tried to delete the link tables it popped out an error message saying:

'''' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.

The database can import the link tables from the same back-end database, but those tables are renamed instead of replacing the old one. How can I resolve this question? Thanks

Colin

推荐答案

参见 Access 2007链接表管理器无法正常工作和 VB中的链接表。其中一个应该可以帮到你。

See Access 2007 Linked Table Manager Not Working Correctly and Link Tables in VB. One of them should help you.

我尝试了两种方法，但是Link表管理器仍然没有显示任何内容。我想我会在需要时通过重新导入链接表来解决这个问题..

I tried both methods, but still the Link table manager still not showing anything. I guess I will solve this solution by re-importing the link tables whenever there''s need..

我看不出任何理由。


您是否将数据库从2003年转换为2007年，或者您是否在2007年将其打开？


您是使用数据库拆分器选项创建原始后端还是手动执行？已知数据库拆分器选项存在问题，这就是为什么大多数开发人员都会手动执行此操作。


如果创建到后端的新链接，则会显示在链接表列表中的下一个你打开数据库的时间？

I cannot see any reason for this.

Did you convert your database from 2003 to 2007 or did you just open it in 2007?

Did you create the original backend using the database splitter option or did you do it manually? The database splitter option is known to have issues which is why most developers will do it manually.

If you create a new link to the backend does that appear on the linked table list the next time you open the database?

这篇关于链接表问题与Access 2007中的无效名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！