Re: MS Access project cant find query
- From: "Sylvain Lafontaine" <sylvainlafontaine2009@xxxxxxxx>
- Date: Tue, 9 Jun 2009 23:52:22 -0400
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)
"AkAlan via AccessMonster.com" <u18147@uwe> wrote in message
news:975c3e172ca29@xxxxxx
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.
AkAlan wrote:
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.
--
Message posted via http://www.accessmonster.com
.
- References:
- MS Access project cant find query
- From: AkAlan via AccessMonster.com
- Re: MS Access project cant find query
- From: AkAlan via AccessMonster.com
- MS Access project cant find query
- Prev by Date: Re: Converting Application from ADP to ACCDB
- Next by Date: Re: Converting Application from ADP to ACCDB
- Previous by thread: Re: MS Access project cant find query
- Index(es):
Relevant Pages
|
