When using ODBC connectivity you can specify a DefaultDir. But with OLEDB you can't use the DefaultDir setting, is there an OLEDB equivalent?
VB Code:
' CONNECTION STRING FOR THE DATABASE ' AccessConnect = "DRIVER={Microsoft Access Driver (*.mdb)};" & _ ' "DBQ=Westfield.MDB;" & _ ' "DefaultDir=" & App.Path & ";" AccessConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=Westfield.mdb;"




Reply With Quote