Re: How I rename a column or insert a new one???

[Michael Bloom <mike@gomi.com>]

******    message to minivend-users from Michael Bloom <mike@gomi.com>     ******



"GRH Computer Corp." wrote:

> ******    message to minivend-users from "GRH Computer Corp." <info@grhonline.com>     ******
>
> This property cannot be modified in linked table.
>

Hello,

I would presume that you are using odbc to update this table, I have been butting my head against
the wall with that particular error since I played with sql-server when 6.5 came out. Odbc
doesn't support field name changes. You will probably have to import the table to a localdb,drop
the table from the access database providing minivend with it's data, make your design changes
and re-export to your odbc datasource.

Hope this helps

Mike

>
> I'm using access 2000
>
> Thanks,
> -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -
> Marie Hernandez
> GRH Computer Corp.
> mhernandez@grhonline.com <mailto:mhernandez@grhonline.com>
> http://www.grhonline.com
>
>
> -----Original Message-----
> From: owner-minivend-users@minivend.com
> [mailto:owner-minivend-users@minivend.com]On Behalf Of Richard Teachout
> Sent: Tuesday, April 27, 1999 1:12 PM
> To: minivend-users@minivend.com
> Subject: Re: How I rename a column or insert a new one???
>
> ******    message to minivend-users from "Richard Teachout"
> <richt@Teachout.com>     ******
>
> >I'm using acess to edit database.
> >How I rename a colum.
>
> Go into the design view and edit it there. Be careful not to change
> the type of column, just the name, as changing the type may
> delete all of the data in that column. Adding a column is just as
> simple as Insert - Row... If you are having trouble with this,though
> you may need an access programmer...
>
>             -Richard Teachout
> *********************************
>     JRT Consulting, L.L.C.
>      richt@teachout.com
>       www.teachout.com
>    Toll-free 888-337-7807
>       CA - 909-337-7807
>       MO- 314-579-3838
> *********************************
> -----Original Message-----
> From: GRH Computer Corp. <info@grhonline.com>
> To: minivend-users@minivend.com <minivend-users@minivend.com>
> Date: Tuesday, April 27, 1999 1:09 PM
> Subject: How I rename a column or insert a new one???
>
> >******    message to minivend-users from "GRH Computer Corp."
> <info@grhonline.com>     ******
> >
> >I'm using acess to edit database.
> >How I rename a colum.
> >-
> >To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> >email with 'UNSUBSCRIBE minivend-users' in the body to
> Majordomo@minivend.com.
> >Archive of past messages: http://www.minivend.com/minivend/minivend-list
>
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to
> Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list
>
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list