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
anyrows.
-----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