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

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Fred Parkinson
> Sent: 02 December 2004 20:45
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] can't relink from MS access after dropping field
>
> 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?

That is quite an old version of the ODBC driver. Newer ones should hide
the dropped columns properly.

Regards, Dave.