Hi Dataminer,
The problem I was experiencing turned out to be related to the way Access pools connections.
If you already have a connection open to a database using integrated security, but then subsequently try to establish a connection (to the same database) using sql server authentication...