Opening a Access Dbase (beginer

[dantb]

Hi all. what I am trying to do is have a Cmd button open a Access Dbase file. The files name is Unit Price.mdb, This is what I have and dont know if it is even close, but know it dont work. Thanks Dan


ODBC.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};Dbq="/UNIT PRICE/DBASE/UNIT PRICE.MDB ";Uid=" & strUserID & ";Pwd=" & strPassword

 

[dantb]

If I run a queri, the conection string looks like this.
"ODBC;DSN=MS Access Database;DBQ=c:Unit PriceDbaseUnit