Thread: Linking a Postgres table on Linux to Ms Access
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
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... > 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 >
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 performancefor 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