Thread

RE: Using Postgres with Access 2000

Michael J Davis <mdavis@sevainc.com> — 2001-01-05T18:44:17Z

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