I suggest using an ALTER TABLE SQL statement - look up ALTER TABLE in access
help (JET SQL) (I always create the statement on my development box - test
it does what I want, then run it through a CF page on the live box...)
HTH
Dan
-----Original Message-----
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: 14 December 2000 10:31
To: CF-Talk
Subject: Making changes to a live Database
Hi,
I have a small change to make to a live database (create a new column in a
table) which is in Access. I don't really want to download it and upload it
again, as I will undoutedly lose data (or visitors will get an error). So I
was wondering what people's experiences are of this kind of situation and
how best to handle it.
Rgds
Will
www.localbounty.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
