I am using MS Access as my database. I connect with my database very well, But when i set MS Access database Password then connection gives error, says cannot connect the file how can i solve this problem.

You need to add the Database Password to your Connection String -
[Code]
";Jet OLEDBatabase Password=MyPassword"
[/Code]
The website is changing the : (colon) and the Upper Case 'D' in the string to a smilie -




[Edited by GeoffS on 09-11-2009 at 08:45 AM GMT]

____________________________
multi-tasking - the ability to hang more than one app. at the same time.

I have also same problem so I have use code
[Code]
";Jet OLEDBatabase Password=MyPassword"
[/Code]
My problem was solved.Thanks to advice.

____________________________
r4 gold