MS Access project cant find query

[AkAlan via AccessMonster.com]

I have a project that works fine but when I try to look at a few of the
queries in design mode I get an error saying MS Access can't find the query.
I can see it in SQL Management Studio and the form that uses it to display
data works just fine. What am I misssing? Thanks for any help.

 

[AkAlan via AccessMonster.com]

I copied the sql statement, renamed the query, recreated a new query with the
statement and all is good. They must have some how got corrupt in Access I
guess.

 

[Sylvain Lafontaine]

Probably that you have some trouble with the owner/schema of the query. You
can have multiple tables or queries with the same name but with a different
owner; for example dbo.MyQuery and user1.MyQuery. Access will give you some
trouble if you don't use dbo and don't log with the same user.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)