Re: dropped columns and ms access - Mailing list pgsql-odbc

From Philippe Lang
Subject Re: dropped columns and ms access
Date
Msg-id 6C0CF58A187DA5479245E0830AF84F42080337@poweredge.attiksystem.ch
Whole thread Raw
In response to dropped columns and ms access  ("David P. Lurie" <dbase4@hotmail.com>)
List pgsql-odbc
Hello,

I have tested what you mention, and I have no problem with deleted columns, after refreshing the linked tables in MS
Access.(2000) They just disappear, if I manually refresh the links with the tools menu, or if i do it programmatically
withthe code I gave you in my previous mail. 

I use the ODBC driver version 7.03.02.09 and 7.03.02.08, they both work fine. I use the "Postgresql" driver, not the
Legacyor Unicode one. Be careful with driver 7.03.02.00, I had some weird problems with it. And pardon me if I'm wrong,
butI think it's the version that the latest installer uses. I had to write a small installer that replaces the dll with
thelatest one. 

Have you tried installing the latest MDAC from Microsoft? I personnally installed the version 2.8 on all the clients,
fromNT4 to XP. With this config, everything runs really fine. 

Philippe

-----Message d'origine-----
De : pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] De la part de David P. Lurie
Envoyé : vendredi, 25. juin 2004 17:11
À : pgsql-odbc@postgresql.org
Objet : Re: [ODBC] dropped columns and ms access

"Philippe Lang" <philippe.lang@attiksystem.ch> wrote in message
news:6C0CF58A187DA5479245E0830AF84F42080336@poweredge.attiksystem.ch...
>I'm not aware of a problem like that, really. Personnally, after each
change to the backend, I relink all tables, programmatically. Here is the
code:

Thanks,

I'm getting close to deploying an app at my office. Programmatically relinking will make deployment easier for my
employees,without having everyone navigate menus and the Data Sources applet in Control Panel. 

My current problem isn't with the relinking process, but with creating new links after table structure modification. I
gotthe dreaded #NAME? field contents odbc error after changing a few table structures, primarily deleting columns. No
previousproblems when columns were added. The cause was not apparent until I found some threads related to this issue,
actuallyin this list, back in 12/2002 through 2/2003. 

My normal sequence of events after a table modification on the backend is to delete the previous link, then create a
newlink. The problems showed up after this sequence, with the error described above. 

The following post from 2/2003 addressed a fix, which seems to work thus
far:

  a.. From: Michael Calabrese <m2calabr ( at ) yahoo ( dot ) com>
  b.. To: pgsql-odbc ( at ) postgresql ( dot ) org
  c.. Subject: Re: Error when accessing tables with deleted columns
  d.. Date: Mon, 3 Feb 2003 14:16:29 -0800 (PST)

----------------------------------------------------------------------------
----

I just wanted people to know  if you have deleted a column in postgres and can not relink the tables in MS Access, the
currentsolution is to dump the database and reload it. 

I was using 7.2.5 version of the odbc driver and tested the CVS that Dave kindly arranged for me.  If someone would
likeme to test a later CVS please just email me with the location of a compiled version and I will attempt to recreate
myproblem. 

Thanks for everyones help,
Michael
 Thanks,

David P. Lurie






---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)



pgsql-odbc by date:

Previous
From: "David P. Lurie"
Date:
Subject: Re: dropped columns and ms access
Next
From: "David P. Lurie"
Date:
Subject: Re: dropped columns and ms access