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