May be held open by any processes accessing it. In other words, you can't delete the .ldb file until it's no longer in use. Can you delete / recreate the DSN? That might at least work to drop open connections ...
>I'm having trouble removing a lock file (.ldb) from an MS Access 2003 >database file that I'm using for a data import (it's actually linked >to a text file). I had to tweak the DB a little and need to upload >the new version to my server, but the ldb file is preventing that. >I've run a bad SQL query against the Access database, which threw a CF >error, in an effort to release the lock, but that didn't work, and >doing things like rebooting aren't an option (shared hosting server). >Is there any other way to force this mdb file lock? > >Thanks > >Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315117 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
