hi, i need to create database in the folder which the user selects
the code below creates database in folder D:\\AccessDb
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=D:\\AccessDB\\shell.mdb;" +
"Jet OLEDB:Engine Type=5");
I have used the folderdialog, and store the location of which the user selects into a string and replace the D:\\AccessDb with the string value, but it give me a error
the dbLocation is the string which holds the folder the user selected
such as D:\data, it does not work, it gives me error
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source='" + dbLocation + "'\\shell.mdb;" +
"Jet OLEDB:Engine Type=5");