Sunday 31 March 2013

Microsoft JET Database Engine error ''80004005'' - System resource exceeded

The shown error does not mean that the server on which the website is hosted is run out of system resources.

Most of the time this error will show up on Shared Server Environment for any website using "Microsoft Access database".  

===================================
Microsoft JET Database Engine error ''80004005''
System resource exceeded.
===================================

The error shows up while running an extremely large query which Microsoft Access cannot deal with.
To resolve the error, the client needs to compact the database and repair the connection string by adding OLEDB JET driver.

1 comment: