Hi All,

I am attempting to connect to SQL Server using a connection string that works on all XP and some Windows 7 machines. Before I go any further the VBA program I have works fine and very quickly on most machines with the connection taking <1 second to complete.

On certain windows 7 machines I am finding that the .open command takes somewhere in the >120s to work. Once I have done this if I try it again the .open opens instantly as per the correct machines. Why is this the case and has any body else come across this?

I have installed my program on quite a few Windows 7 machines and initially always get the same results however in most cases either by changing permissions, security settings etc the problem eventually goes away. ie I must have done something to correct things.

I now have a few stubborn machines and for the life of me I can't work out what might be going on.

Can anybody help?

Thanks