Doesn't have the DAO control a connection string builder? (if you drop the ADO recordset control on a form, you can build a connection string with that, copy it to your source and ready (at least that's the way i build my connectionstring...)