错误消息“指定字段”A“可以引用SQL语句的FROM子句中列出的多个表 [英] Error Message "The specified field "A" could refer to more than one table listed in the FROM clause of your SQL statement

问题描述

我正在清理我正在运行的Access数据库，当我尝试打开我的3个查询时，他们给了我同样的错误消息。他们在2天前跑步时工作得很好。我最大的问题是我无法打开查询。它不会是
让我打开SQL视图或任何东西来修复错误。

I was cleaning up the Access database I'm running at work and when I tried to open 3 of my queries they gave me this same error message. They worked just fine like 2 days ago when I ran them. My biggest problem is that I can not open the Queries up. It won't let me open the SQL view or anything to fix the error.

任何建议都会有所帮助！

Any Suggestions would help!

谢谢！

推荐答案

在进行清理之前，您是否制作了备份副本？如果没有，也许您可​​以尝试使用QueryDef对象来提取SQL语句并在必要时进行修改。

Did you make a backup copy before doing the clean up? If not, maybe you could try using a QueryDef object to extract the SQL statement and modify it if necessary.

只需要我的2美分......

Just my 2 cents...

这篇关于错误消息“指定字段”A“可以引用SQL语句的FROM子句中列出的多个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！