pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRE: Using Postgres with Access 2000
2+ messages / 2 participants
[nested] [flat]
* RE: Using Postgres with Access 2000
@ 2001-01-05 18:34 Scott Teglasi <scotty@mediaglue.net>
2001-01-05 18:55 ` Re: RE: Using Postgres with Access 2000 Joel Burton <jburton@scw.org>
0 siblings, 1 reply; 2+ messages in thread
From: Scott Teglasi @ 2001-01-05 18:34 UTC (permalink / raw)
To: 'pgsql-general@postgresql.org' <pgsql-general@postgresql.org>
Let me rephrase my words. :)
I have created postgresql tables with pgaccess. I am unable to add new
records to those tables using Microsoft Access 2000. How do I remedy this
situation, and also, is there a way to create tables within Microsoft Access
2000 on the Postgresql server.
appologies for any confusion.. :)
Scott Teglasi
-----Original Message-----
From: Scott Teglasi [mailto:scotty@mediaglue.net]
Sent: Friday, January 05, 2001 1:25 PM
To: 'pgsql-general@postgresql.org'
Subject: Using Postgres with Access 2000
Hello. I am trying to use Microsoft Access 2000 with Postgresql 7.0.2
installed on a Mandrake 7.2 box. I have configured my ODBC driver and DSN
on the windows box, and have configured Postgresql to allow my machine to
connect, and have installed its ODBC driver as well. I can view and edit
tables, however I'm unable to add new records to any of the tables that I've
created using pgaccess. My question is, how can I allow people to add
records to tables using access, and also, is there a way to create new
tables on the postgres server using Access as well?
A reply would be greatly appreciated, thank you.
Scott Teglasi
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: RE: Using Postgres with Access 2000
2001-01-05 18:34 RE: Using Postgres with Access 2000 Scott Teglasi <scotty@mediaglue.net>
@ 2001-01-05 18:55 ` Joel Burton <jburton@scw.org>
0 siblings, 0 replies; 2+ messages in thread
From: Joel Burton @ 2001-01-05 18:55 UTC (permalink / raw)
To: Scott Teglasi <scotty@mediaglue.net>; +Cc: pgsql-general@postgresql.org; pgsql-interfaces
> Let me rephrase my words. :)
> I have created postgresql tables with pgaccess. I am unable to add
> new records to those tables using Microsoft Access 2000. How do I
> remedy this situation, and also, is there a way to create tables
> within Microsoft Access 2000 on the Postgresql server.
Questions about Access + Pg are most appropriate to pgsql-
interfaces, BTW.
By default, ODBC connections to Pg are read-only. Did you turn off
BOTH read-only option boxes?
You can create tables by using the DDL statement as a 'Pass-
through query' in Access.
More complete answers can be found in the Pg+Access FAQ at
www.scw.org/pgaccess.
Good luck,
--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-01-05 18:55 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-05 18:34 RE: Using Postgres with Access 2000 Scott Teglasi <scotty@mediaglue.net>
2001-01-05 18:55 ` Joel Burton <jburton@scw.org>
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