This is my current code, I I know its error, but I don’t know the correct code:
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F :\search.mdb;pwd=nit"
conn.ConnectionString = "Provider= Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword;"
is the correct format of the connection string.
Check http://www.connectionstrings.com/access-2007 for more information.
I have a password protected mdb file but I cannot access it on vb.net It. I don’t know the correct code to define the password.
This is my current code, I know its error, but I don’t know the correct code:
p>
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\search.mdb;pwd=nit"
< p>
conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword;"
is the connection The correct format of the string.
Check http://www.connectionstrings.com/access-2007 for more information.
< /p>