Access database wont unlock

[jgladnick]

I am finding it impossible to unlock an access database.

the specs:
Windows 2000 server
CF 5.0
IIS
Access db created in Access 2003

The problem: the damned ldb file is there. I have attempted to re-verify the
database in CF admin, as well as intentionally crashing the database by calling
tables that dont exist. The only way i can unlock it is if no one uses the
database for like 20-30 minutes and it unlocks itself. Its very odd. any
ideas?

[xcoldnet]

DURA LEX SED LEX

That's the way it is, once the database is on the server you have to wait
20-30 minutes of inactivity before the damn .ldb file disappear.

If you have to do frequent maintenance of the databse the best way is to
create an interface online, a kind of admin web page with login that will let
you manipulate the records in the database even when the .ldb is present.

IHTH,

Dario

[paross1]

Make sure that you do not select Maintain Connections for your Access
datasource in CF administrator, as this is not recommended. (See the old tech
note attached) I believe that the recommendation still applies.

[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17034[/url]

In ColdFusion Administrator, modify every Access ODBC Data source and set the
following (you will need to click the CF Settings button to see these):
Buffer Size = 0 (ODBC only)
Page Timeout = 600 (ODBC only)
Uncheck Maintain Database Connections

Phil

[MattRobertson]

Its easy to get rid of the ldb file. Just throw a known bad query at the
database.

<cfquery datasource="foo" name="bar">
SELECT bingo FROM nameo WHERE yoo='Hoo'
</cfquery>

A goofball query like the above will immediately break the lock and you can do
as you please... assuming of course you do not have a table where these
parameters are correct :D

That link that paross1 gave you is very, very old information and no longer
applicable unless you are using CF 4 or CF 5. Even so, I wouldn't go anywhere
near an OLE connection in CF. I tried it back in the day (CF 4.5 I believe)
and found all sorts of weird things using it... Not something you have to worry
about now that its the 21st century :D You should use a standard JDBC
connection, which didn't exist back when that article was written.

I would, however, definitely uncheck "maintain database connections", although
I'm not sure the reasons for its use still exist... Do it out of paranoia until
told differently by someone who knows. Be advised its use will torpedo
performance, if such a word as 'performance' can be used in association with
Access.

[paross1]

That link that paross1 gave you is very, very old information and no longer
applicable unless you are using CF 4 or CF 5.

If you notice, the original poster is using ColdFusion 5, so I would say that
the uncheck maintain database connections recommendation would apply.

I would, however, definitely uncheck "maintain database connections"

That is all that I was saying. Also, I don't know where you got the OLE
connection idea, as I was referring to an ODBC connection to Access.

Phil