Hi,
I have tried opening my connection string from excel to access with the following code.

cn.Open "Data Source=" & ThisWorkbook.databaseString & "\Test_Database.mdb;Provider = Microsoft.Jet.OLEDB.4.0;", UserId = "Admin", Password = "aa"

Database String = I have already defined earlier.
My Problem is whenever I try to connect a password protected access database with the code above, it throws me run-time error. Removing the UserID & Password portion works fine for me when database if not protected.
I want to connect to a password protected access database. Where I am going wrong?

regards,
Dwij