How to use remote database by ODBC? 
Author Message
 How to use remote database by ODBC?

Hi,

I use ODBC to map my database on the other machine to drive "F".
So, the database file is mapped to "F:\jane\test_user.MDB".
I put the following lines on my VB code:
 Set OldWs = DBEngine.Workspaces(0)
 Set OldDb = OldWs.OpenDatabase("F:\jane\test_user.MDB")

However, it gives me error indicates that "Database cannot be opened".
Do you know the reason?

          Jane



Sun, 21 Nov 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. ODBC to database on remote machine

2. How to export a database as ORACLE database using ODBC

3. using access databases by using ODBC

4. Accessing remote database using ADO

5. Remote Database using ADO

6. Accessing Remote Oracle database using VB code.

7. Using ODBC to handle Access databases

8. compacting a database connected using odbc

9. Specifying a database in code that uses ODBC drivers

10. Connecting vb4 to an ingres database using datadirect odbc driver

11. Compacting an Access Database using ODBC 2.0

12. Using the Data Control to control ODBC database ?

 

 
Powered by phpBB® Forum Software