[thelist] Altering Design of AccessTable from Coldfusion

[Raymond Camden]

If it's possible via SQL's ALTER command, you can do it. Just do:

<cfquery .......>
	alter ....
</cfquery>

=======================================================================
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email    : jedimaster at macromedia.com
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda

> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org] On Behalf Of jon steele
> Sent: Saturday, March 09, 2002 12:44 PM
> To: TheList Evolt
> Subject: [thelist] Altering Design of AccessTable from Coldfusion
>
>
> Hi list,
>
> 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?
>
> I need to set the "Indexed" field of a table (as seen in the
> Design view when you open up a table
> in MS Access) to "Yes (No Duplicates)". You gotta be able to
> do this remotely by sql, right? I
> know this can be done in MySQL...
>
> Any help is appreciated as always.
>
> Jon
>