How To Unlock Microsoft Access Database Using Cold Fusion

There are two ways to accomplish this. First (and preferred) way is to run a dummy query:

<cfquery name="unlock" datasource="users">
select money from nothing
</cfquery>


Second way is to use an undocumented Coldfusion function:

<cfset null = cfusion_dbconnections_flush()>

Mind you this will flush all your database connections, so unless you really need to I would just stick with the first method.

  • 0 Utenti hanno trovato utile questa risposta
Hai trovato questa risposta utile?

Related Articles

ColdFusion ODBC errors

There are two general classes of ODBC errors: 1) When ODBC attempts to connect to the datasource...

CFML Syntax Errors

Cold Fusion will report the template where the error occurred. It will also offer tips for...