Re: problem connecting to ADO programmatically

Pieter Zijlstra wrote:

Here is the connection string I use on normal (unprotected) MDB files
for just reading them.

adoConn.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0' +
';Data Source=' + objSettings.DatabaseName +
';Mode=Read' +
';Persist Security Info=False';

On the component level I have KeepConnection and LoginPrompt set to
False. I can and am changing the connectionstring on the fly based on
user settings.

Thanks for the tip. I will hope that it solves my problem.

--

Bill
.