Re: [CFTALKTor] Database Locks

[Bob Keleher]

Mike,   A couple of approaches:   1. in the CF administrator, uncheck 'maintain database connections' for this datasource (should be done for all Access databases anyway , see http://www.macromedia.com/v1/handlers/index.cfm?ID=1540&Method=Full)     2. use the undocumented tag CFUSION_DBCONNECTIONS_FLUSH(). - disconnects all currently connected CF datasources (won't affect connections currently being used).   Bob   ----- Original Message ----- From: Mike To: [EMAIL PROTECTED] Sent: Wednesday, February 20, 2002 10:54 AM Subject: [CFTALKTor] Database Locks Hello All,   I have a question regarding a daily process that is starting to cause us some issues with the way our ISP handles our database connection.   We have a program that creates an access database overnight. This database is then sent FTP to our ISP where it over writes the database for a website that allows one of our clients to view data which is contained in the data base.  This is fine if nobody has accessed the website in the last little while the database is over written no problem.  The issue I have is when a person views a webpage a 9:00 am and I want to over write the database at 9:15 there is a lock on the database.   I guess I am looking for a way to import and modify data in the database without actually overwriting the database.   Does anyone know how to do this in Coldfusion?   thanks   Mike