Created March 2003.

Ways to break a lock on an Access Database with Cold Fusion

CFUSION_DBCONNECTIONS_FLUSH()

<cfset temp = cfusion_dbconnections_flush()>

UPLOAD A NEW DATABASE ENTIRELY

Or you could upload the database with a new name and change the ODBC connection to point to the new file.

A BOGUS QUERY

  <CFQUERY name="bogusQuery" datasource="#DataSource#">
    SELECT   bogusField
    FROM   bogusTable
    ORDER BY  bogusField ASC
  </CFQUERY>