Re: can't relink from MS access after dropping field

Hi, you need to refresh the linked table.
Under the tables section, right click on the table then click "linked
table Manager".
Select the table again and click refresh.

Any time you make a change to a table in postgres, you must then refresh
it in MS Access
or strange things start to happen.

Fred Parkinson wrote:

>After dropping a field in a postgres table this morning
>(alter table tstudents drop company_id)
>I now get an error message from Access when I try to link to that
>table:
>
>.........pg.dropped.31........
>is not a valid name etc.
>
>In the get external data>link tables>ODBC databases() dialog box the
>name of the table looks normal: public_tstudents
>
>using ocbc driver 7.2.5.0
>
>I am hoping that after vacuum runs tonight the problem will go away; in
>the meantime I will use a backup copy of my access app which has the
>original link intact and still works.
>
>Any ideas?
>
>Thanks
>
>Fred Parkinson
>Association of Bay Area Governments
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
>