Hi,

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?

The connection string details I gave you, Ian, were for the BO Mapper. You still must have a valid connection in order to produce a schema. So whether you are connecting to the MDB via the BO Mapper or in your run-time application, you must supply a valid connection.



Next, I see that you have this supplied in the BO mapper, and that when you get the schema information on the BO you are getting the exception. The very same connection is used. I have tried this on the most recent build on my side and it is working. So possibly I am not using the same version of an MDB or security settings. If you can supply a simple Access database with a password setup like your environment, I would be more than happy to try it out here so that I can see what you are experiencing. Thanks.

Thanks for the offer, I'll get something sorted.