Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    linking to an odbc tables and queries in access (2

    I have a mdb whose tables are linked from a external database via odbc. When I tried to link to a query or table in this msaccess data base I can not see the queries based on linked tables or even any of the linked tables. So why not or what can I do to get around this. I can see the imported tables but not the linked tables

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: linking to an odbc tables and queries in access (2

    Are you doing this from an Excel workbook (you originally posted this in the Excel forum) or from an Access database?

    If the latter, you'll have to link directly to the external database; you can't link to linked tables in Access.

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: linking to an odbc tables and queries in acces

    Then I assume that I should create a make table query and link to that.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: linking to an odbc tables and queries in acces

    > create a make table query and link to that

    I assume that you meant "... and link to the table created by the make-table query". You can't link to a query.

Posting Permissions

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