Just write a query to a bogus table in your DSN and it will break the lock ie:
<cfquery name="killDSNConnect" dataource="[YourDSN]"> SELECT * FROM NOTHING </cfquery> -----Original Message----- From: Terry [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 10:30 AM To: CF-Talk Subject: Re: Script to release lock on an Access database Here's what I do: Upload new db with a different name, then rename. *********** REPLY SEPARATOR *********** On 2/7/2003 at 11:16 AM Phillip Cave wrote: >It's be awhile since I've used MS Access as the database for a web >application, so I'm not sure this question is even relevant for CF5 or MX. > >Is there a script out there that will release the lock that put on an >Access >database once a data source has been setup? We've got a client who >constantly updates an access database with new fields/tables etc. I seem to >remember that you couldn't just FTP the new database to the server because >of the lock. We're not giving this guy CF Admin access because the box is a >shared hosting environment. > >Any ideas are appreciated. That particular server is CF5 btw. > >Thanks, > >Phillip > >.................................... >Phillip Cave >ColdFusion Developer >Carol/Trevelyan Strategy Group >202.448.5212 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
