can't relink from MS access after dropping field - Mailing list pgsql-odbc

From Fred Parkinson
Subject can't relink from MS access after dropping field
Date
Msg-id s1af0e86.082@groupwise.abag.ca.gov
Whole thread Raw
Responses Re: can't relink from MS access after dropping field
Re: can't relink from MS access after dropping field
List pgsql-odbc
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

pgsql-odbc by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: ODBC driver for Windows & future...
Next
From: Jaime Casanova
Date:
Subject: Re: can't relink from MS access after dropping field