We have a system as follows:

client machines with access database, updating to local server with SQL database updating to cloud based SQL database. This alows us to have other phisical locations updating to the cloud SQL database.

The problem I have is when we run a 'match' process (matching clients to products) the application stalls and says 'Retry database'. When we click to retry the process of the match does continue but it is a pain to have to be there for what should be an automatic process.

I guess the problem is due to any delays over broadband and things timing out too quick.

Is there a simple way to increase the 'time out' value.

Thanks in advance,