The following suggestions can improve your Access database connectivity:
In the ColdFusion Administrator, select Server>Settings and set Limit Simultaneous Requests to 5-7 per processor.
In the ColdFusion Administrator, select Server>Data ODBC Sources and modify
the following ColdFusion Settings for each ODBC Access data source:
Buffer Size = 0 (ODBC only)
Page Timeout=600 (ODBC only)
Clear the Maintain Database Connections check box on the ColdFusion
Settings page.
Install the latest ODBC or OLE DB drivers from Microsoft on your ColdFusion Server.
Cycle the ColdFusion services each night using the \cfusion\bin\cycle.bat file.
If you receive an Operation must use an updateable query error message when you attempt to run a ColdFusion template that updates or deletes from an Access database, see Knowledge Base Article 11928.
If you get an access denied error when writing to Access, try to recycle the ColdFusion services.