Well, i really got stuck into this problem.
In my project i wish the user to be able to select a database
using an open file dialog box.
I am unable to connect with this database.
i used the code..
createConnection.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Tostring(ofdselectdatabase.FileName)"
and
createConnection.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=ofdselectdatabase.FileName"
The exception raised was that the compiler understood the two lines:
Tostring(ofdselectdatabase.FileName)
and
ofdselectdatabase.FileName
as the path itself rather than a container referencing the path.
I am really stuck here an need to complete this project within the week.plz Help. Urgent