Thread: Postgres and Access

Postgres and Access

From
"Nathalie Boulos"
Date:
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.

I would greatly appreciate any feedback and docs concerning this subject.

Regards

Nathalie

_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail


Re: Postgres and Access

From
Robert Treat
Date:
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