Re: interfacing ms-access with postgresql?

From: Stefan Huber <schweinsaug(at)crosswinds(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: interfacing ms-access with postgresql?
Date: 2001-06-11 14:36:16
Message-ID: 5.1.0.14.0.20010611163236.00aa85a8@pop.crosswinds.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


> I'd like to interface ms-access 2000 with postgresql 7.1.1. What my
>objective is is to create a database in access, then upload it on to a web
>server, and via an interactive form and postgresql have various data
>returned, or to enter new data from the web site. Is this possible?
>Thanks.

Get the latest ODBC driver for Windows (should be on your local mirror in
~/pub/odbc/versions, for example
ftp://gd.tuwien.ac.at/db/www.postgresql.org/pub/odbc/versions/ , which is
my closest one )
The create a connection to your "webdatabase" using a system DSN and stream
your data through it by connecting to the tables in Access and creating
updatequeries.
Of course, you must be able to connect to the PostgreSQL Port on the remote
machie, otherwise, it might become quite tricky.

HTH,
Stefan

--
I don't have a solution but I admire the problem.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Christof Glaser 2001-06-11 15:02:26 Re: installation in windows
Previous Message Bruce Momjian 2001-06-11 04:26:52 Re: Intentionally splitting data in a table across files.