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.
De: Tyrone Omidi [SMTP:tyrone(at)sbsworldwide(dot)com]
Date: mardi 30 mai 2000 13:40
Objet: Help with pgsql / Access
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
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
pgsql-interfaces by date
|Next:||From: Kovacs Zoltan Sandor||Date: 2000-05-31 10:11:16|
|Subject: Re: ODBC driver for Windows - Problems|
|Previous:||From: Ira Waxberg||Date: 2000-05-31 05:13:59|
|Subject: PostgreSQL JDBC error: Missing or erroneous pg_hba.conf file|