Re: @#$%^& Access and PostgreSQL

On Tue, 15 Jun 2004, Philippe Lang wrote:

> Hello,
>
> Firstly, beleive me, Access linked to Postgresql through ODBC works
> really well. The driver works fine, I'm using it every day, several
> clients too.

Used to be for me also a year or three ago.  This new go-round (I spent
three plus years not having to deal with MS Access) it has been anything
but smooth.  The few times before it was a slam dunk.

> How do you "query and fiddle with the data in Access"? You have to use
> a ***linked ODBC table***, and in this case, updates are transparent.
> You simply modify the data, and the updates are generated for you. Is
> that what you are trying to do?

Philippe, this is the term I was missing.  'Linked' ODBC tables.  For some
reason when I created the Access portion last week there was no ODBC data
sources for linked tables ... I think.  Probably had something else in
mind when I tried using this option.  No there wasn't.  It's working now.

Thanks to all for suggestions and a couple of clue-sticks.


Rod
--
    "Open Source Software - You usually get more than you pay for..."
     "Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL"