Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008

    Unanswered: ODBC Link From Access Not Showing Tables

    When I try to use the ODBC wizard in Access 2010 to link to tables in SQL Server 2005 Express, I can only see what appears to be system type tables. The SQl date tables are not listed in the dialog box for me to select from. I set up a DSN for the SQL tables. They are valid tables because I can go into SQL directly and work with the tables. I can also link to them via Excel. Both Access and SQL are in the same PC and I am the only user.

    Why is my Access ODBC linking wizard not listing the SQL data tables?

  2. #2
    Join Date
    Nov 2003
    Christchurch, New Zealand
    Totally guess here but... have you correctly specified your database or are you defaulting to the master database some how??

    Are you connecting as a specific user or trusted authentication?

    What is the default database for the user you are connecting as?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts