[CFTALKTor] Database Locks

[Mike]

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