Terry,
I've been under the impression that you couldn't use Access to create
tables in PostgreSQL, but I'm happy to be wrong. How do you export the
tables? Is it from within Access?
Thanks,
Peter Darley
-----Original Message-----
From: pgsql-odbc-owner@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org]On Behalf Of terry
Sent: Tuesday, August 06, 2002 11:54 AM
To: mount.zion@sympatico.ca; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] PostgreSQL server Linux mandrake
Rob,
You will need to use the Postgres ODBC driver for windoze that is
available from the Postgres web site.
You will not be able to create a new Postgres database from
Access, but you must do that in Linux. After that you can create
or use Access tables by first exporting them to Postgres via the
ODBC connection. After they are exported, you can link to them
from Access via the linked table manager to use them.
It works well, but be aware of the data type differences.
Good Luck,
terry