Coldfusion error

[bsmithdesigner]

I have recently taken over the network for a non-profit which includes their Access database and CF server. Though I have some experience with these I am mostly a front-end person. Lately I have been receiving errors that look like this:
-------------------------------------------------------
An error occured on Page:
/members/goToSynergy.cfm
form.QueryString: issn=0963-7214&date=2006&article=00409
form.Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727)
form.Type: APS

form.diagnostics:
The request has exceeded the allowable time limit Tag: cfhttp
The error occurred on line 43.
form.generatedContent:

Form MID Value: #form.MID#,#url.mid#
-------------------------------------------------------------------

I was wondering if anyone could point me in the right direction from here. Is this something I can fix with a simple reboot? Thanks a billion for any ideas.

-bSmith

[niceguyeddie]

I'm not an expert on CF, though learning, but the error is an execution time limit error. Could be a bad loop in the code, or could be a general memory leak / server slow down causing it. If the problem is isolated to that page, that would be where you should start looking for a mismatch on process loops.

[imaginemn]

I would get rid of access as your database. The error itself is just a timeout error. Could be a very long query and the server setting are timing out when trying to return too much data or the database is too slow with too many connections while trying to execute another query.

I would start by exceeding the timout settings. If it still happens then try getting rid of access. Acess it ok on a small website but eventually you will run out of the number of simultanious connections allowed.