Re: Linking a Postgres table on Linux to Ms Access

codeWarrior wrote:
> go in the other direction... Convert your table in MS Access to use a
> pass-through query to the postgreSQL table. Connect yoour MS Access pass
> through table to postgreSQL using OBBC.
>
> Even better: Drop MS Access completely and just use postgreSQL. Access is a
> totally inferior technology.

Not for a front end it isn't :)

Link Table is what this guy is looking for.

Joshua D. Drake

>
>
> ""carter ck"" <carterck32(at)hotmail(dot)com> wrote in message
> news:BAY101-F28C98428FE76C9CB51D1D3D5A20(at)phx(dot)gbl(dot)(dot)(dot)
>> Hi all,
>>
>> Is there any way that I can synchronize a table in Postgres on Linux with
>> another table in Ms Access?
>>
>> The requirement of the assignment is as following:
>>
>> In postgres, there is a table called message_received. Whenever we insert,
>> update or edit this table, the table in Ms Access should also be updated.
>>
>> Advices and suggestions are all welcomed and appreciated.
>>
>> Thanks
>>
>> _________________________________________________________________
>> Get an advanced look at the new version of Windows Live Messenger.
>> http://get.live.com/messenger/overview
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 9: In versions below 8.0, the planner will ignore your desire to
>> choose an index scan if your joining column's datatypes do not
>> match
>>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/