Hi all:
I'm pretty green to both Access and SQL, so any help is appreciated! I'm working with Access 2007 and SQL Server Express v9.0. When I link to SQL by way of ODBC, I want to draw from a View that was created in SQL, but when I try I get a message saying "...database engine could not find the object...". Other tables with the dbo_ prefix come through okay, but my view will not. It is obviously not recognizing the view, so is there an easy solution? Thank you for your time and help!