Web Wiz Forums - Error Mssage

Print Page | Close Window

Error Mssage

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=13314
Printed Date: 12 April 2026 at 4:04am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error Mssage

Posted By: sfbay420
Subject: Error Mssage
Date Posted: 11 January 2005 at 6:34pm

Microsoft JET Database Engine error '80004005'

System resource exceeded.

/forum/forum/common.asp, line 499

I just got this error

Im running 7.9 access

What do I do?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 12 January 2005 at 6:01am

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.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: sfbay420
Date Posted: 12 January 2005 at 6:06am

I've never seen it before...

I only have 100 members...
at the most theres only 2-4 on at a time...
...If that

Is it still worth the switch?

Posted By: WebWiz-Bruce
Date Posted: 12 January 2005 at 6:26am

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.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting