Accessing Linked Oracle Tables in Access Using ODBC in VB 
Author Message
 Accessing Linked Oracle Tables in Access Using ODBC in VB
We have linked Oracle Tables in the Access DB and have saved the
password while linking. While trying to access the data using ODBC calls
to the Access DB in the VB code gives an error: S1000 - [Microsoft
Access 97 Driver]- ODBC Call Failed.

The rdoTables Collection does not even see these linked tables in the
Access DB.

Does anyone have a solution/workaround for this problem?



Sun, 11 Feb 2001 03:00:00 GMT
 Accessing Linked Oracle Tables in Access Using ODBC in VB

You can check DBEngine.Errors (0 to DBEngine.Errors.Count - 1) to get
the full description of the ODBC error.

AZ

Vineeta Gangla Prabhu schrieb:

Quote:

> We have linked Oracle Tables in the Access DB and have saved the
> password while linking. While trying to access the data using ODBC calls
> to the Access DB in the VB code gives an error: S1000 - [Microsoft
> Access 97 Driver]- ODBC Call Failed.

> The rdoTables Collection does not even see these linked tables in the
> Access DB.

> Does anyone have a solution/workaround for this problem?



Sun, 18 Feb 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Strange ODBC errors using DAO to access linked tables in Access .MDB

2. Preventing table update when linking oracle database table to access via ODBC

3. linking an excel spreadsheet to an access table using vb

4. Linked Table between SQL 6.5 and Access 2.0 or Access 97 through ODBC

5. Accessing 32bit Access from a 16bit VB app using ODBC

6. SQL Server linked tables in Access 2K databases using ODBC

7. Problems using ODBC to link Microsoft Access to Sybase Tables

8. ASP ADO Error - ODBC Connection Failed - Using SQL Server Linked Tables In Access

9. Linking Access 7.0 to SQL Server 7.0 tables using ODBC File DSN

10. Using JDBC/ODBC for Access DB that links xBase and Fox tables

11. Linking Access 7.0 to SQL Server 7.0 tables using ODBC File DSN


 
Powered by phpBB® Forum Software