Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    5

    Question Unanswered: Access Linked Tables and SQL Server.

    Hi,

    i want to upsize Access Databases to SQL Server 2000.
    I have two databases. Let A and B. A contains a table,
    linked to table t of B.
    The upsize wizard of Access creates for the A's linked table
    a table that contains the data of table t at the moment of the
    upsizing.
    These data are static data and don't change when i modify the
    data of table t.
    What i have to do to fix it?

    Thanks in advance.

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Post Re: Access Linked Tables and SQL Server.

    RE:
    Hi, i want to upsize Access Databases to SQL Server 2000. I have two databases. Let A and B. A contains a table,
    linked to table t of B. The upsize wizard of Access creates for the A's linked table a table that contains the data of table t at the moment of the upsizing. These data are static data and don't change when i modify the data of table t.

    Q1 What i have to do to fix it? Thanks in advance.
    A1 Rework your tsql code to refer to the table in DB B.

    Brief Explanation:

    It is possible to use a fully qualified name to refer to the table in DB B, (when working with DB A). For Example: (run in "Query Analyzer", isql, osql, etc.)

    Use A
    GO

    Select * From B..t
    Go

    [The example would return a full result set from Table t (in the B DB) even though the current DB context is DB A (Use A sets the context to DB A).]

Posting Permissions

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