I've been using this (it's out of a function I have that is called with tcMdb, tcId, tcPwd and returns loConn
lcDir = JustPath(tcMdb)
lcDatabase = JustStem(tcMdb)
lcConnString = "Driver={Microsoft Access Driver (*.mdb)};DefaultDir=" + lcDir + ;
";DBQ=" + lcDatabase + ;
";User Id=" + tcID + ;
";Password=" + tcPwd
loConn = CreateObject('ADODB.Connection')
loConn.Open(lcConnString)
It's been working ok for me.
Alan
>Hi,
>
>1. go on DBC Connections
>2. Click New
>3. Check optionButton Connection_String
>4. Click on ... button
>5. Select Access DSN
>6. Click On
>
>Now you see Connection String.
>
>AFAIK, for Access you cannot connect without a DSN.
>
>Fabio