Resolved ...

After dozens of trial & error guesswork this line worked :
KA_DB.Open "Provider=SQLOLEDB;Server=GARYSPC\SQLEXPRESS;Database=KADB; Trusted_Connection=yes"
It seems that the TrustedConnection=yes was the key ...