Modify the table using standard SQL scripts... ALTER TABLE YourTable ADD COLUMN ColumnName Text(255)
This will add a column of type text with a 255 character limit to your table. HTH, Jeff Garza ----- Original Message ----- From: "Bryan F. Hogan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 14, 2002 12:14 PM Subject: access db 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 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
