Have two datasources & databases. Have person upload datasource 2 while the site uses datasource 1. Do a query of datasource 2, loop through it and update datasource 1. Maybe have a scheduled task do this at a time that would be least disruptive. There are probably better ways to do this, but since you are using an access db in the first place, I imagine that simple is good.
>>> "John McKown" <[EMAIL PROTECTED]> 12/10/01 03:36PM >>> Customer has Access database that he uploads to CF Server via FTP. Access database is a datasource for his site. When site is being viewed, he cannot upload a newer copy of the database because the file is locked. Any creative solutions besides "disconnect the datasource"? John McKown, President Delaware.Net, Inc. 28 Old Rudnick Lane Dover, DE 19901 e-mail: [EMAIL PROTECTED] phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 cell: 302-363-0071 icq: 1812513 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
