From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Fred Parkinson" <FredP(at)abag(dot)ca(dot)gov>, <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: can't relink from MS access after dropping field |
Date: | 2004-12-03 08:56:04 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E4527C67@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Fred Parkinson
> Sent: 02 December 2004 20:45
> To: pgsql-odbc(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Gosling, Oliver | 2004-12-06 15:11:15 | calling nextval function |
Previous Message | Mike Fahey | 2004-12-02 22:34:24 | Re: can't relink from MS access after dropping field |