TADOConnection LogInPrompt

I've just received and installed Delphi 2006 Professional. Everything went
perfectly with the install so I tried creating a small test database
program. This works except that despite setting loginprompt to false on the
ADOConnection, when I run the program it's still asking for the username and
password (which I've set in ConnectionString). The interesting thing is that
if I set loginprompt to true then I get the dialog twice. It's as if the
ADOConnection and the ADOQuery are both asking for a user name and password
if loginprompt=true but only the ADOQuery is if loginprompt=false. Any idea
what I've missed?

I should mention that I've been using Delphi since version 2 (and Turbo
Pascal before that) and I've been using ADO components to access Access
databases since D7 so hopefully I've not done anything truly daft.

TIA

Ken Davies


.