CODEWITHSUNDEEP
vb.netms-access
user225269
user225269

Reputation: 10913

Connecting to an Access database that has a database password

I've password protected an mdb file but then I cannot access it on vb.net. I don't know the correct code for defining the password. this is my current code, I know its wrong, but I don't also know the correct code:

conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\search.mdb;pwd=nit"

Upvotes: 5

Views: 26545

Answers (2)

Wade73
Wade73

Reputation: 4509

I believe the connection string should look like this:

conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:Database Password=MyDbPassword;"

Here is a link to a site which can help with connection string questions ConnectionStrings.Com HTH

Upvotes: 4

Steve Strickland
Steve Strickland

Reputation: 151

conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword;"

is the correct format for your connection string.

Check out http://www.connectionstrings.com/access-2007 for more info.

Upvotes: 6

Related Questions