Thanks for the input Doc Man, but this is a Website not an application.
It's hard to count the connections when there are 100+ websites all using 1 connection string from the same IIS process.
Did the Compact to all the databases.
There are still errors going on.
I can see certain problems I might be able to test to further prove my point.
I am going to make those changes and report back.
Due Date of Wed.
Yes I have backups of all the Databases, they are saved else where.
Maybe I should repair them all and re-post them.
Ya the ASP Classic pages output an error from time to time.
I will try that and see how the day goes.
Going to take a while tho, there are 50+ of them.
There is no linking of tables, the system is used like a glorified excel sheet.
Everything is a Read operation.
provider=microsoft.jet.OLEDB.4.0;
Is the connection string, it is in ASP Classic, this is a on a Websystem.
Thanks for the response.
Guess I should add this part.
Does the number of Connections Span the number of databaseS?
So if I have 10 Databases, does each connection count go towards the Number of Tasks?
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...