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.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).]