This is how I connect to my databases (if it helps)

VB Code:
  1. Dim cn As New ADODB.Connection

  2.  
  3. cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _

  4.                  "Data Source=" & App.Path & "\DataBaseName.mdb"