错误消息“指定字段”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屋!