Skip site navigation (1) Skip section navigation (2)

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

From: Mike Fahey <mfahey(at)enter(dot)net>
To: Fred Parkinson <FredP(at)abag(dot)ca(dot)gov>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: can't relink from MS access after dropping field
Date: 2004-12-02 22:34:24
Message-ID: 41AF9870.5040302@enter.net (view raw or flat)
Thread:
Lists: pgsql-odbc
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
>  
>

In response to

pgsql-odbc by date

Next:From: Dave PageDate: 2004-12-03 08:56:04
Subject: Re: can't relink from MS access after dropping field
Previous:From: Jaime CasanovaDate: 2004-12-02 21:44:21
Subject: Re: can't relink from MS access after dropping field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group