how do i ODBC link access to a SQL View?

  • 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!

  • your view also has the dbo prefix?

  • Have you checked view permissions?

    Regards Ramon

    Regards Ramon

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply