Linked tables

[Guest_imported]

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.

 

[JamesGordon]

Off of the top of my head.
The VB ODBC connection is it read-only, check the parameters to open.
Or the recordsets, dynasets or what ever they are called also have a type e.g. read-only, forward-only, dynaset etc. check the call parameters.