Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL

From: Valerio Santinelli <tanis(at)mediacom(dot)it>
To: robert(at)chalmers(dot)com(dot)au
Cc: "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL
Date: 1999-01-18 23:35:56
Message-ID: 36A3E17C.EBF0EF2C@mediacom.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces

Robert Chalmers wrote:

> Hi,
> I'm pretty new to postgresql, but am reasonably familiar with MSAccess, and I
> see here that Valerio can export tables from Access to pgsql. How is this done?
> And using forms from Access related to pgsql databases?
> This could be invaluable. While I'm at it, does anyone know where there might
> be some sample code for a shopping cart using pgsql as the database and php3?
>
> Thanks for any info, especialy on getting msaccess and postgresql working
> together.

Well.. I'm in a hurry so I'll be quick and concise.

To access the PostgreSQL database from a win32 machine you can simply install the
ODBC driver (there's a link on www.postgresql.org) and then you've got to configure
your database on the linux machine to accept calls through TCP/IP from other
machines. The way to do that is fully explained in the postgresql manual, but if
you need more help on the topic just ask and I'll try to explain everything in a
better way as soon as I get some time to write a full e-mail ;)

After you configured your database on the linux box, just create a new dataabse in
MSAccess and "connect external tables.." and tell him that you're using an ODBC
database. You'll be prompted to enter some details about the database, expecially
the IP address of the machine the database resides on and its name, then if
everything goes fine you'll end up with a list of the tables contained in your
postgresql database.

Have fun! :)

--

C'ya!

Valerio Santinelli a.k.a. TANiS
[tanis(at)mediacom(dot)it]+:+[http://www.mediacom.it/~tanis]

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Silvio Emanuel Barbosa de Macedo 1999-01-19 01:25:24 QueryBuffer 20K exceeded - still...
Previous Message David Hartwig 1999-01-18 22:57:57 Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL

Browse pgsql-interfaces by date

  From Date Subject
Next Message Robert Chalmers 1999-01-19 01:44:05 Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL
Previous Message David Hartwig 1999-01-18 22:57:57 Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL