Help Connection to Access thru ODBC using DAO 
Author Message
 Help Connection to Access thru ODBC using DAO

I am trying to make a connection to an Access97 DB via ODBC.  Then only
error I get is "connection failed"

Here is my code

myDBname ="{*filter*}.mdb"

Set myDB = DBEngine.Workspaces(0).OpenDatabase(myDBname, dbDriverNoPrompt,
False, ODBC;UID=sa;PWD=;DSN=DrugTest")

I have set no PWD or User name at this time.
Any Ideas?

Brian



Sun, 23 Sep 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Reusing VBA/Access Forms thru DAO/ODBC/ADO

2. Using the COUNT function in Access accessing db2 tbls thru ODBC

3. Using DAO to create pass thru queries in access 2000 - references problem

4. Using DAO to create pass thru queries in access 2000 - references problem

5. Query read-only connection with ODBC using DAO?

6. VB3 using Access 2.0 db thru ODBC

7. Help: Access Sybase thru ODBC?

8. Help! Access MDB thru ODBC (No respones)

9. Strange ODBC errors using DAO to access linked tables

10. VB loosing connection to ODBC thru Novell

11. Connection Error through ODBC to Access Using VB

12. ODBC connections using ODBC

 

 
Powered by phpBB® Forum Software