Assuming you are using MSAccess:
Create an empty DB and create linked tables that point to the tables in your
real DB. The ODBC connection can remain open, and you can upload a new DB
at any time by overwriting the real DB. This works as long as you don't add
any tables - you'll still have to modify the DB with the linked tables.
The other route is to talk the host into turning off "Maintain database
connections" in the CF Administrator for your ODBC source. That's the dealy
that's locking your file.
Good luck!
Jeff
> -----Original Message-----
> From: Guy J. McDowell [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 08, 2000 11:15 AM
> To: CF-Talk
> Subject: Remote DB Alteration
>
>
> Hello CF'ers
>
> Situation:
> Database and sites hosted externally, site created internally.
> Currently if any changes to the datasource's structure are made they
> are made locally and then uploaded to the host, who has to shut off
> the CFServer and restart it. This requires scheduling a time and is
> unacceptable. Also, the uploaded datasource may corrupt/overwrite the
> data as it is not up to date. Employer will not spring for extra
> datasources to be hosted. ( multiple applications and domains, one
> datasource, yay! ;) )
>
> Goal:
> To be able to add tables to the datasource without scheduling a
> shutdown and uploading entire datasource.
>
> Resources:
> MS Access 97
> CF 4.5
> CuteFTP
> Budget =$0
>
> Is this possible? Please direct me to resources that will show me how.
>
> Also, anyone know what the 20 or so CFML tags supported by CFExpress
> are?
>
> Yours In Conservation,
>
> Guy J. McDowell,
> Webmaster
> The Ontario Federation of Anglers & Hunters
> E-mail: [EMAIL PROTECTED]
> Phone: (705) 748-6324 ext. 262
>
> P.S. You may want to check out the fresh new look of www.OFAH.org
> Launched 1st November 2000.
> Don't forget our other great sites:
> www.AuctionForWildlife.com - Your chance to make your bid for
> conservation.
> www.EcoEd.org - an online adventure for kids in grades 1 through 8.
> www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
> www.AHTV.com - Your online companion to the Angler and Hunter
> Television show.
> www.OHEP.net - Where to find out and learn about the Ontario Hunter
> Education Program.
>
>
>
> ------------------------------------------------------------------
> ------------------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
