Yeah, you can do it, but not sure of the syntax as it's been years since I've used Access. Google will have the answer. However, I'd strongly recommend switching to a "real" database (one that uses a client-server model). MSDE (which is a light version of MS SQL Server that is free) is probably a good choice if you're already using Access. I've personally had great success with MySQL, which is GPL. There are myriad other options, ranging from free to very expensive. And "real" database engine is centered around SQL, rather than around a custom GUI (as Access is). Most ship with a GUI to interface with them, but the GUI runs SQL commands rather than interfacing witth the raw database directly (as Access does).
cheers, banreyb On 10/15/06, nick way <[EMAIL PROTECTED]> wrote: > hi there, i often find myself needing to add new columns to a table to my > access datasource. currently i choose a quiet time of day, download the db > from my live server, quickly open it up and add in my new column, then upload > it back to the live server - whilst hoping that a) none of my visitors > changed anything during this process and b) that no one exeperinced any errors > > ...not ideal! > > is there a way to create new columns in tables (and even to create new tables > perhaps) via CF so i dont have to do this downloading / uploading procedure > to my mdb documnet (i'm using an access database by the way) > > i'm thinking something like this??... > > <cfquery datasource="blah"> > CREATE COLUMN name="new_variable" type="yes/no"...? > </cfquery> > > is there such a thing? thank you very much indeed for any assistance you can > provide. > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256823 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
