Error when connecting to pass protected db

[vma]

Hi all,
I'm tring to connect to a password protected microsoft access mdb file and I get an error about "Could not find installable ISAM"
The connection string is like this:

OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + 
				"User Id=admin;Password:xxx;Jet OLEDB:Engine Type=5;Persist Security Info=True;" +
				"Data Source=C:\\Documents and Settings\\Mihai\\Desktop\\Imobiliare\\Vita\\BD\\anunturi.mdb");

The thig is that if I try to open a mdb file that has no password and I remove the part about User Id and Password from the conn string it works.
Can someone help me out?
Thank you!

[cjard]

You are setting the password in the wrong place. It's a common problem with passworded MDB and it drove my bonkers for weeks. Do this:

make a new file on the desktop called A.UDL
Double click it
Go through the tabbed screens and make data entries suitable for your database. (Jet OLE DB Provider)
DO NOT FILL IN THE PASSWORD BOX IN THE CONNECTION TAB
On the ALL tab, 5 item down is DatabasePassword
Set THIS password entry to the DB password

Test the connection

Open the UDL file in Notepad. There is your needed connection string.


The conecntion string looks like:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=some database;Persist Security Info=False;Jet OLEDB:Database Password=db_password

[vma]

So where do I find this db_password and how do I deal with this password data base when I'm giving the aplication to someone else?