Fred,
What do you mean "my database is not Access" ? You first post contained the
line:
Set dbsNorthwind = wrkJet.OpenDatabase("Northwind.mdb")

NickHK

"fred" wrote in message
...
TK, my database is not Access and is not a single file. In fact it is a
client server application (U/SQL) that has a client ODBC driver. So you
see
I cannot fully qualify the path because there is no path as such.

Obviously it works from within the Microsoft Query with just the string
"ODBC;DSN=TIMS.udd" so I hope I can connect a Recordset using this same
information?

Regards,
Fred



"TK" wrote in message
...
Fred

help me out here

I said

'You should fully quality the path to your file

Dim db_Name As String

'// this is where Access lives on this computer
db_Name = ("C:\Program Files\Microsoft Visual Studio\VB98\NWind.mdb")
'// where does it live on yours ( )

tried your routine by setting the DB_CONNECT_STRING to
"ODBC;DSN=TIMS.udd"
but it doesn't connect.

does that look anything like the example!
lets get connected then we will work on th rs
TK