Connect to database via VBA/DAO/ODBC

[Oliver]

 Posted by:  Oliver <oli...@demus-online.de> 

Hello,
I am trying to connect to a database via VBA.
This is my connection string:

Set dbNorthwind = OpenDatabase("MYDB", False, False,
"ODBC;DSN=SQLBase;UID=sysadm;PWD=sysadm")

When I run this command, it comes up with a login window to the DB.

Can anybody tell me, on how I can avoid this window?

Thanks in advance,
Oliver

[Oliver]

 Posted by:  Oliver <oli...@demus-online.de> 

OK, I fixed it on my own, this is the following solution:

Set dbNorthwind = OpenDatabase("MYDB", dbDriverNoPrompt, True,
"ODBC;DSN=MYDB;Database=MYDB;UID=sysadm;PWD=")

But now I have a problem, to get a recordset out of the Database. I run
the following statement:

Set rdShippers = dbNorthwind.OpenRecordset("Select * from myTable")

and I get a message back, that it can not find the table. But it is
there. Can somebody tell me, what I am doing wrong?

Thanks in advance,
Oliver