导入时访问跟踪名称自动更正查询列 [英] ms access track name autocorrect query columns on import

问题描述

我无法将查询导入Access 2010中的新Access容器。这在以前的版本（2003,2000,97）中总是有点问题，跟踪名称自动关闭并且只要导入本地表和链接到外部表FIRST，然后导入查询，这不是一个问题。现在我尝试做同样的事情，但Access 2010在我的所有列名称中使用Expr1，Expr2，Expr3等等在基于其他查询组合的查询中。再次，这对我来说在以前的版本中没有问题，但我似乎无法找到解决方案，也没有在网上找到任何东西。



实际上，出现了什么问题是当将对象导入新容器时，MSysAccessObjects没有被更新。它应该在这个数据库中有1120行。但它只有3.从来没有发生过这种情况。似乎无法让它工作。

I'm having trouble importing queries into a new Access container in Access 2010. This was always a bit of a problem but in previous versions (2003, 2000, 97), with track name autocorrect off and as long as you import local tables and link to outside tables FIRST, then import queries, this was not a problem. Now I am trying to do the same thing but Access 2010 is aliasing all my column names with "Expr1", "Expr2", "Expr3", etc. in queries that are based on combinations of other queries. Again, this did not present a problem for me in previous versions but I cannot seem to come up with a solution and am not finding anything online.

Actually, what appears to be the problem is that when importing objects into the new container, MSysAccessObjects is not being updated. It should have 1120 rows in it in this db. But it only has 3. Never had that happen before. Cannot seem to get this to work at all.

推荐答案

不要复制对象！复制数据库。在MS Access 2010中打开该副本。下一步使用选项： CompactRepair [ ^ ]。它应该解决你的问题。如果没有，请通知我。

Do not copy objects! Copy database. Open that copy in MS Access 2010. Next use option: CompactRepair[^]. It should resolves your problem. If not, please, notify me.

这篇关于导入时访问跟踪名称自动更正查询列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！