asp website with access database freezes for 30-60 seconds intermittently. The site is on an internal 2008 server. About 25 users access the site simultaneously. Is it just the limits of access or can i do something to improve the situation? change any timeout/refresh settings anywhere? or could it be a problem with the network?
A:
Are you sure you that no one is viewing data using a sql enterprise program ?
I have noticed that when you do a select whatever from ... query, and you do not commit the transaction (in the viewing program), you can have freezes when accessing the same database using a web site interface (like web pages using asp).
Please specify the database you are using, since that can make a difference.
Edelcom
2010-03-08 13:14:01
Er, the original version of the question had ACCESS as a tag and ACCESS in the title. How much more specific about the database involved could he have been?
David-W-Fenton
2010-04-11 01:07:28
Yep, you are sure. Had read Access as the verb. Sorry.
Edelcom
2010-04-11 10:31:41