Database Access: Lock? Readonly? What to do...

[RuBot]

I have a CF site that uses MS Access databases for many different things, from
creating the actual site, to doing Admin-related stuff like adding, editing,
maintaining content.

When I have a database open manually and someone hits a site that uses it, it
gives them an error! I don't want this. I'm confused as to the proper locking
techniques in regards to sessions, etc.

Each site has an application.cfm. Not all users need to log in to access the
main site, but users need to log in to edit the site (affect the database
records).

[Fodor]

I ran into this problem doing a tutorial on Macromedia's site.
[url]http://www.macromedia.com/devnet/coldfusion/articles/guestbook_01.html[/url]

My result is at [url]http://www.billcory.net/guestbook.swf[/url]

I can see the Microsoft Access DataBase's data but I cannot write to it. The
reason is that the .mdb is locked with a .ldb file of the same name. How do I
get around this? I was told to unlock the .ldb file, but I can't find any
information within Access or ColdFusion for doing so.

:wine;

[jdeline]

Run a query that fails, wrapping it in CFTRY/CFCATCH. The crash will delete
unlock the database.


<CFTRY>
<CFQUERY NAME="crash" ... >
SELECT id FROM thisTableDoesNotExist
</CFQUERY>
<CFCATCH >
<!--- here's where you wind up when the query fails. the database is unlocked
--->
</CFCATCH>
</CFTRY>
<!--- now continue on your merry way --->