Using Postgres with Access 2000

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

1) Make sure the odbc data source you are using has the read only flag checked off.
2) Create a primary key index for the table. Access97 requires a primary key or it will not allow you to edit or add any rows.

-----Original Message-----
From: Scott Teglasi [SMTP:scotty@mediaglue.net]
Sent: Friday, January 05, 2001 11:35 AM
To: 'pgsql-general@postgresql.org'
Subject: RE: Using Postgres with Access 2000

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

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)