I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column.
BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

