Hi everyone
I have developed an application that has MS Access frontend linked to sql server backend database.
Recently the sql server admin informed me that my frontend application is causing the sql server to suspend few times and he had to restart the server each time. he sent me the log showing suspended along with the username that I use.
I have the timeout in access options to 30.
how I understand that the frontend runs a query or a code in order to pull data from sql server db, but when its taking too long to fetch the results it suspends the sql server database.
I thought sql server would have some safety to handle this.
So can some of the experts here please give me some suggestions on
what is the actual issue,
what would be causing it
what to do to deal with it.
and what are the best practice in vba to avoid such problem.
Many thanks for all your help!
I have developed an application that has MS Access frontend linked to sql server backend database.
Recently the sql server admin informed me that my frontend application is causing the sql server to suspend few times and he had to restart the server each time. he sent me the log showing suspended along with the username that I use.
I have the timeout in access options to 30.
how I understand that the frontend runs a query or a code in order to pull data from sql server db, but when its taking too long to fetch the results it suspends the sql server database.
I thought sql server would have some safety to handle this.
So can some of the experts here please give me some suggestions on
what is the actual issue,
what would be causing it
what to do to deal with it.
and what are the best practice in vba to avoid such problem.
Many thanks for all your help!