Linked tables

[Danny Depecker]

Colleagues,

I have the following situation:

On a Windows NT platform, a program developped in Visual Basic 6.0 with an
ODBC-connection to an Access-database. But in the Access-database, there
are several linked tables to an ORACLE database.
In the ACCESS environment, there's is no problem writing in the linked tables
towards ORACLE.
But, out of my VB6 application it is only possible to read data in linked
access table . Writing or modifying into this linked table to ORACLE always
returns an ODBC error call.

When I make the same setup on a Windows 2000 platform, everything (reading,
writing in the ORACLE linked Access-table) works just perfect!

QUESTION:

Can anyone give me a hint how I can make this work on the NT4.0 platform
or why it is not possible to make it work on NT4.0?


Thanks.

[Michael McGrath emtsolutions.com]

It sounds like you are using a newer version of the ODBC drivers with Windows
2000, however there are better ways to get to the data besides using linked
tables in Access buy going through vb6/ado directly.

Mike


"Danny Depecker" <dd@vanas.be> wrote:
>
>Colleagues,
>
>I have the following situation:
>
>On a Windows NT platform, a program developped in Visual Basic 6.0 with
an
>ODBC-connection to an Access-database. But in the Access-database, there
>are several linked tables to an ORACLE database.
>In the ACCESS environment, there's is no problem writing in the linked tables
>towards ORACLE.
>But, out of my VB6 application it is only possible to read data in linked
>access table . Writing or modifying into this linked table to ORACLE always
>returns an ODBC error call.
>
>When I make the same setup on a Windows 2000 platform, everything (reading,
>writing in the ORACLE linked Access-table) works just perfect!
>
>QUESTION:
>
>Can anyone give me a hint how I can make this work on the NT4.0 platform
>or why it is not possible to make it work on NT4.0?
>
>
>Thanks.
>