asp website with access database freezes for 30-a minute occasionally. The website is with an internal 2008 server. About 25 customers access the website concurrently. Could it be only the limits of access or can one make a move to enhance the problem? change any timeout/refresh configurations anywhere? or can it be an issue with the network?
Are you certain you that we're not viewing data utilizing a sql enterprise program ?
I've observed that after you perform a
choose whatever from ... query, and you don't commit the transaction (within the viewing program), you could have freezes when being able to access exactly the same database using an internet site interface (like webpages using asp).
Please specify the database you're using, since that may really make a difference.