Can someone tell me what the heck is wrong with the code below? I keep
getting an "Datasource name not found and no default driver specified". I
have tried every damn way I can think of to be able to use App.Path to my
database but I keep getting this error. If I go with the wizard which set's
a fixed path then everything works fine but I don't want a fixed path.
Thanks
Dim db As ADODB.Connection
Dim rs As ADODB.Recordset
Set db = New ADODB.Recordset
db.Provider = "Microsoft.jet.OLEDB.4.0"
db.Open App.Path & "\Scheduling.mdb", "admin", ""
Connectstring = "Provider=" & _
"Microsoft.jet.OLEDB." & _
"4.0;data source=" & _
App.Path & "\Scheduling.mdb"