Error Mssage

This is a server error and means that the server is overloaded and has run out of resources.

It is often coursed by the web server running out of memory or when the server runs out of access database connections from it's limited connection pool.

Each server only has a limited amount of database connections in it's pool available for all sites on the server (most hosts have around 20 to share with all sites on the server).

If you get this message often it is usually a sign that the server is overloaded or some sites on the server are using bad programming that don't release the database connection back to the connection pool once they have finished using them.

Access database do course allot of problems due to the high amount of resources  it requires from the web server due to it being a flat file database system, so if possible you should use MS SQL Server instead to prevent errors like you mention.

The problem often clears after a while when the server frees up server resources.


Edited by -boRg- - 12 January 2005 at 6:03am

Maybe not in your case, but forums do require allot of server resources and Access does course allot of problems.

If you want your forum to grow you are better off starting with MS SQL Server from the start.

It would get ride of problems like you are having as the MS SQL Server is not a falt file like access so the whole thing doesn't need to be loaded into memory each time someone comes to your forum.

The MS SQL Server is also usually located on a sepporate server to the web server.

Access was designed as a simple flat file desktop database system with a limited number of connections and a limited maximum size.

MS SQL Server, on the over hand, was designed for large corpartion databasse that can be many 1,000's of gig in size with an almost unlimited number of connections to the database at the same time.