I am trying to write an application that allows me to transfer the data from an 'old style' access database to a 'new style' SQL database. I have restructured the target database and I have an app that allows me to interact with the SQLdatabase via BO's that I have written based on the table structure.

I want a BO for the Access database so in the VS iDE I have set a connection to the table and have attempted to create a BO. When I try to configure the BO (Business Object Properties) by selecting OLEDB and the 'Select Source' button I get the following response:

An error occurred while attempting to open the data source with connection string:

[Provider= Microsoft.JET.OLEDB.4.0;DataSource= "MyDataSource";]

Exception: Not a Valid password.

When I click OK it just returns to the "Select OLE DB Table" and I have to Cancel.

How do I get the password into the connection string at this juncture?