Linked Tables

Results 1 to 2 of 2

Thread: Linked Tables

  1. #1
    Join Date
    Dec 1969

    Default Linked Tables

    Howcome if I create a linked table in access when i try to create a database connection to it, it will only see tables that are normal tables and not linked.

  2. #2
    Join Date
    Dec 1969

    Default RE: Linked Tables

    Linked tables are a feature of the Access *program*, not of the underlying database engine.<BR><BR>Note that you *can* use the equivalent of a linked table in SQL (using the Jet driver) by specifying the table&#039;s full location in the FROM clause. <BR><BR>For example:<BR><BR>SELECT * FROM tableName IN "c:xyzabcfoo.mdb" ...<BR><BR>See MS Access "Help", Contents and Index, and search for "IN Clause".<BR><BR>

Posting Permissions

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