pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Help with pgsql / Access 2+ messages / 2 participants [nested] [flat]
* Help with pgsql / Access @ 2000-05-30 11:39 Tyrone Omidi <tyrone@sbsworldwide.com> 0 siblings, 0 replies; 2+ messages in thread From: Tyrone Omidi @ 2000-05-30 11:39 UTC (permalink / raw) To: pgsql-interfaces 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* RE: Help with pgsql / Access @ 2000-05-31 08:40 Nicolas Huillard <nhuillard@ghs.fr> 0 siblings, 0 replies; 2+ messages in thread From: Nicolas Huillard @ 2000-05-31 08:40 UTC (permalink / raw) To: 'Tyrone Omidi' <tyrone@sbsworldwide.com>; pgsql-interfaces 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-05-31 08:40 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2000-05-30 11:39 Help with pgsql / Access Tyrone Omidi <tyrone@sbsworldwide.com> 2000-05-31 08:40 RE: Help with pgsql / Access Nicolas Huillard <nhuillard@ghs.fr>
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