I am having a problem with the "Boss"
We have been using an Access DB for 20ish years (I know a good Run)
And Finally we have upgraded the servers from 2000 (*boo) to 2012 (YAYA)
We did a Lot of testing, and the server seemed to Do Ok, there were not any errors.
Fast forward a year give or take, and we are seeing Many
[Microsoft][ODBC Microsoft Access Driver] Too many client tasks.
Now I know the problem is the number of connections to the database, but I have to PROVE with out a Shadow of a Doubt this is the problem.
I tried to find something in the Performance monitor but that is not helping.
I installed Total Access Admin
It shows 5 connections, but those are not tasks.
And those connections never close.
I am not sure what else to do, and it's driving me up a wall.
Any help to get my sanity back would be GREAT!!
Thank you for reading
//Rantish
We have been using an Access DB for 20ish years (I know a good Run)
And Finally we have upgraded the servers from 2000 (*boo) to 2012 (YAYA)
We did a Lot of testing, and the server seemed to Do Ok, there were not any errors.
Fast forward a year give or take, and we are seeing Many
[Microsoft][ODBC Microsoft Access Driver] Too many client tasks.
Now I know the problem is the number of connections to the database, but I have to PROVE with out a Shadow of a Doubt this is the problem.
I tried to find something in the Performance monitor but that is not helping.
I installed Total Access Admin
It shows 5 connections, but those are not tasks.
And those connections never close.
I am not sure what else to do, and it's driving me up a wall.
Any help to get my sanity back would be GREAT!!
Thank you for reading
//Rantish