G'day Nicholas.
You might like to look at the contents of ftp://ftp.sdc.com.au/pub/repl.
It is a general purpose database replicator for any pair of databases which
inderstand ODBC.
Cheers,
Stephen.
Nicolas Huillard <nhuillard@ghs.fr> wrote:
> This description is a way to export tables from Access to Postgres. I know how to do this.
> What I'm looking for is a tool to synchronize the data between the same table inside Access and Postgres, ie : a new
recordin Postgres should be transfered to Access, and the same the other way.
>
> Thanks.
>
> -----Message d'origine-----
> De: Allan Huffman [SMTP:huffmana@ppc.pims.org]
> Date: mercredi 27 octobre 1999 15:25
> À: Nicolas Huillard; pgsql-interfaces@postgreSQL.org
> Objet: Re: [INTERFACES] Replication between MS Access and PostgreSQL
>
> You can export the MS Access tables to Postgres as long as the ODBS.exe has been run and set up from the
> control panel "32 ODBC" configuration panels that are loaded from the .exe. You will need the Host name,
> database name, User and Password, and use the default PostgreSQL Postmaster port number. The Postmaster
> has to be running with the database allocated but the table must not already exit. Then do the following:
>
> ....
>
> ************
--
========================================================================
Stephen Davies Consulting scldad@sdc.com.au
Adelaide, South Australia. Voice: 08-8177 1595
Computing & Network solutions. Fax: 08-8177 0133