Have two databases - one links to the other. Set up the DSN on database 1 (which links to database 2) - upload database 2.
Don't have any web based record administration on database2 though. or else you'll have to worry about synchronizing data. Eric Dawson From: "John McKown" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: Disconnecting Data Sources for Upload? Date: Mon, 10 Dec 2001 15:57:44 -0500 Ben, That sounds like a good solution. Thanks. 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 -----Original Message----- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 3:33 PM To: CF-Talk Subject: Re: Disconnecting Data Sources for Upload? 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
