I can't believe I'm asking this as I've done it hundreds of times in the past, but I can't get it right now.

I've created a Data Source for an Access DB situated in c:\Temp.

All I'm trying to do is open the database with DAO, and it is just not happening. I keep getting error no. 3423.

Code:
  Set DB = DBEngine.Workspaces(0).OpenDatabase("PassThroughTest", dbDriverNoPrompt, False, "ODBC;DATABASE=;UID=;PWD=;DSN=PassThroughTest")
I've tried various different connect strings (I just choose to post this one as it is the last one I tried).

Can anybody tell me what is wrong before I go crazy.

[Edited by Stevie on 09-28-2000 at 02:29 AM]