From: Nicolas Huillard <nhuillard@ghs.fr>
To: 'Tyrone Omidi' <tyrone@sbsworldwide.com>
To: pgsql-interfaces@postgresql.org <pgsql-interfaces@postgresql.org>
Subject: RE: Help with pgsql / Access
Date: Wed, 31 May 2000 10:40:53 +0200
Message-ID: <01BFCAEC.B31B0BD0@agen.int.ghs> (raw)
In Access, you try to directly create queries using ODBC connections. What I do is link external ODBC tables into Access (File/External data/Link tables, in word-translated french), then use these new "local" Access tables to create queries. You can then use the full graphical query editor.
The only problem with this is that all joins will be executed locally, and not remotely, AFAIK.
Nicolas Huillard
-----Message d'origine-----
De: Tyrone Omidi [SMTP:tyrone@sbsworldwide.com]
Date: mardi 30 mai 2000 13:40
À: pgsql-interfaces@postgresql.org
Objet: Help with pgsql / Access
Hi,
Looking for some basic info using Access as a front end to PostgreSQL.
I know nothing of SQL (but willing to learn) and a little experience of
Access, lots of Unix/Linux.
I have doadloaded and installed the odbc driver, unticked all the readonly
stuff. (I'm using postgres 7 with Access2000 )
I have setup a system DSN. From within Linux I have created a user, a
database and made changes to the pg_hba.conf file.
My problem is I don't know how to connect Access to postgres now this is
setup.
I found some info as below.
Create a new Access file, select queries, click new, close show table dilog,
from query menu select SQL specific & pass-through. Select odbc source and
click ok. ( At this point all seems well and asks to save password )
I did try a few SQL commands in the passthrought box but it comes up with
"ODBC-call failed error creating the table ps(#17)
What I was thinking here was that I could create, change tables to store
data, it would save to postgres and using Access as a front end many people
could get access to it ?? Do I have the wrong end of the stick, is there
more to it. Unfortunatly I can't find any basic info this.
Any help appreciated
Thanks
very newbie
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: nhuillard@ghs.fr, tyrone@sbsworldwide.com
Subject: RE: Help with pgsql / Access
In-Reply-To: <01BFCAEC.B31B0BD0@agen.int.ghs>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox