to change the timeout setting, but no-one has been able to tell me how....... YET!!!!

Any ideas.....

This is the error

Code:
Microsoft OLE DB Provider for SQL Server error '80040e31' 

Timeout expired