[thelist] Altering Design of AccessTable from Coldfusion

[matt g]

> From: jon steele <jjsteele22 at yahoo.com>
> I was wondering how to change the design of an Access table via sql from
> coldfusion? Can this be
> done with a sql query or is something else needed?

You can save a file with
<cfquery name="addindex" datasource="yourdsn">
    WHATEVER SQL WORKS WITH YOUR DB HERE ;
</cfquery>

Just put it on the server and type in the URL. It will either work, or throw
an error with diagnostics.

It is advisable to try the SQL on a non-live db if you have that option.
Otherwise it can get pretty sloppy before you get it right.

matt