problem with connection strin in ado.net

hi all, i am trying to connect to an access database, it has a password called : "xxx" , i am using a connection string as following but it keeps pop up an oledb exception.

when i use the same connection string on a database without a password, i have no problem

here is the problemetic connection string

VB Code:

db.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\mainx.mdb;password=maged;username=admin"

thx in advance

Have you tried ConnectionStrings.com :confused:

I use something like this:

VB Code:

Public Const ACCESS2K = "Provider=Microsoft.Jet.OLEDB.4.0;Password='';User ID=Admin;Data Source=C:\mydb.mdb"