Yo conecto con un mdb con ruta relativa de la siguiente manera:
app.config o web.config
<connectionStrings>
<add name="CYBER" connectionString="Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=..\..\CYBER_MAIL.mdb"
providerName="System.Data.OleDb" />
<add name="Inventari.My.MySettings.InventariConnectionS tring"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=|DataDirectory|\CYBER_MAIL.mdb"
providerName="System.Data.OleDb" />
</connectionStrings>
Codigo vb de conexion:
Public Function abrirConexion() As Boolean
Try
Dim strCon As String
strCon = System.Configuration.ConfigurationManager.Connecti onStrings("CYBER").ConnectionString()
Me.Conex = New OleDb.OleDbConnection(strCon)
Me.Conex.Open()
Return True
Catch
Return False
End Try
End Function