> I know of both the bad query and cfusion_dbconnections_flush() methods for > clearing an access db connection, but neither seem to work in MX. Is > there > any programmatic way to clear connections to an access db so that you can > pull/delete it from the server?
The db_connections)_flush(), as well as another similar tag, no longer work in ColdFusion MX. The bad query should work, though. I had a harrowing problem with a lockfile, and the bad query definitely removes it. If it's still not working, then there's something else keeping the lockfile in place. Make sure the database isn't open on anyone's machine. If you have it open in another window, or if your sysadmin left it open last time he looked at it, then you'll get a lockfile that won't go away. Also, and maybe this is just superstition, but way back in Access 95, I seem to remember persistent lockfiles that could be removed by restarting. HTH, -- Austin Govella Grafofini ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
