Database locked up

[Avenestra]

I'm using an Access database and it seems to think it's being access by a
process even though it's not. I can pull data, but cannot save any changes. I
tried using

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

which simply returned an error and also this

<cfset null = cfusion_dbconnections_flush()>

Which said it's not supported in MX7. I thought about changing the name of the
DB and reloading on the server, but I can't change my DNS, I have to get
someone else to do it and yes, it would take time I don't feel I have. Anyone
have any suggestions?

[adotfilm]

Give a try with this to flush all connections.
<CFOUTPUT>#cfusion_dbconnections_flush()#</CFOUTPUT>

[JMGibson3]

I'll bet your Admin has checked the Maintain Connections box in Cold Fusion
Administrator. This should be left unchecked and the .ldb should disappear
(unless you look during the few milliseconds that a query is active). The
Admin may be under the mistaken impression (I've never noticed ANY difference)
that keeping that box checked is more efficient. You have to talk him out of
it somehow.

[Avenestra]

Thanks for the updated flush command, but that didn't work either. I got an
error message that it's not supported in MX. I guess I'll have to work on the
admin even though he's in it up to his ears and I hate to bother him.

[niranjtb]

We do have the same ldb file issue with MX 7.01 and 'Maintain connections' is
not checked in the CF Admin section for this DSN.

We have tried the ?false query? method which has been suggested by many, with
no luck.

Any help is appreciated.

[dr_bozak]

it is was so convenient to be able to flush the db connections in 5.

is there really no way to get rid of the .ldb file, without deleting the
datasource via cfadmin?

broken query method doesn't seem to work ...

[H3ath0r]

I spent the last hour and a half searching all the boards for a
solution to programmatically disable a db connection in CF MX (while
I was waiting for an unaccessed Access lock file to time out - how
long WILL that take, anyway?).

Guess I'll have to approach the admin of our shared server...

But if anyone finds a solution PLEASE email me: [email]hc@blueboulder.com[/email] or
reply here. :cry: