Linking a Postgres table on Linux to Ms Access

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.

""carter ck"" <carterck32@hotmail.com> wrote in message
news:BAY101-F28C98428FE76C9CB51D1D3D5A20@phx.gbl...

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@hotmail.com> wrote in message
news:BAY101-F28C98428FE76C9CB51D1D3D5A20@phx.gbl...

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/

hello all,
I like to know what you think about using dblink to construct serious syncronous and asyncronous replication.
I'm work with this idea only for test and think this is possible or almost possible because I don't know the performance for long distances but in the same network, like inside one company, the performance is good.

thanks for advanced,

--
Ivo Nascimento
Iann tech - Desenvolvendo solu��es com performance e seguran�a
http://www.ianntech.com.br

Iannsp <iannsp@gmail.com> writes:

I like to know what you think about using dblink to construct serious syncronous and asyncronous replication.

I think it'd be a lot of work and at the end of the day you'd pretty
much have reinvented Slony-I ... why not just use slony?

regards, tom lane