Re: Postgres and Access

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Nathalie Boulos <nathalieboulos(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres and Access
Date: 2003-06-06 14:46:17
Message-ID: 1054910777.29944.331.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, 2003-05-27 at 09:26, Nathalie Boulos wrote:
> Hello everyone,
>
> I was able to open postgresql tables on linux from MS-access on windows
> using the ODBC found on postgresql.org website.
>
> I was wondering if there is a way that a postgres database on linux sees and
> modifies access or fox-pro database files.
>

no, postgresql is a database back-end and can only work directly on it's
own back-end files. Contrast to access which is both a database
front-end and back-end; the access front-end can talk to other database
back-end's via odbc. With that said, you can convert back-end database
files from access to postgresql, one such program that does this is
pgadmin (pgadmin.postgresql.org).

hth,

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kambiz Kermanizadeh 2003-06-06 15:02:35 unsubscribe
Previous Message Andrew Sullivan 2003-06-06 14:44:10 Re: Starting postmaster as a service (newbie)