Prev: How can I use relationships to auto-create records in my subform?
Next: Add table to split database
From: DrEvil on 19 Apr 2010 16:54
I got this done using pass-through query, I'm now able to retrieve data from
DB2 and speed seems good. My pass-through query looks like this:

SELECT *
FROM OPENQUERY(TSTESA5, 'SELECT * FROM DON1.ETAX_W2')
where W2_FIDN = '68052889600'

TSTESA5 is the linked server name
ETAX_W2 is the table
W2_FIDN is column


Amir



"Armen Stein" wrote:

> On Mon, 12 Apr 2010 07:32:01 -0700, DrEvil
> <DrEvil(a)discussions.microsoft.com> wrote:
>
> >I'm not sure how to set-up ODBC connection to MSSQL 2005 ent. to show linked
> >server tables
>
> So you're saying you can link to normal SQL tables from Access, but
> you can't see the linked SQL tables in the same database? I don't
> understand. Maybe someone else can clarify why this wouldn't work.
>
> Another approach is to build SQL views on the remote DB2 tables and
> link to those from Access instead...
>
> Armen Stein
> Microsoft Access MVP
> www.JStreetTech.com
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: How can I use relationships to auto-create records in my subform?
Next: Add table to split database