VB.NET – Connect to Access Databases with Database Passwords

I have a password protected mdb file but I cannot access it on vb.net. I don’t know the correct code to define the password.
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:

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>

Leave a Comment

Your email address will not be published.