[AccessD] Renaming a field through code

I don't think it can be done. I just ran a couple of experiments and while
not definitive they lead me to conclude that you cannot do much of anything
to a linked table.

Arthur

On Fri, Jul 18, 2008 at 2:22 PM, Rocky Smolin at Beach Access Software <
rockysmolin at bchacc.com> wrote:

> Bill:
>
> That will change the length of the field.  But I need to change the name.
>
> I consulted SQL: Access to SQL Server (by a couple of notorious Apress
> authors) - under the ALTER info but there doesn't appear to be a SQL
> command
> for this.
>
> IIRC, there was a thread a long time ago to the effect that you had to add
> a
> new field with the new name, copy all the data from the old field to the
> new
> field, and then delete the old field.  But I'm hoping I'm disremembering
> that and that there's a method now to rename a field.
>
>
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
> www.bchacc.com
>