Thread: Postgres connect with Access

-----Original Message-----
From: Differentiated Software Solutions Pvt. Ltd [mailto:diffs@vsnl.com]
Sent: Tuesday, August 01, 2000 4:20 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Postgres connect with Access

Hi,

 

We are facing a problem similar to one reported earlier. We've connected to postgres via ODBC, we're able to see the data but not edit it. Details as follows.

 

We've installed postgres ODBC driver and restarted postgres with -i option.

We've connected to postgres using ODBC and linked to all tables.

For each table we've assigned the unique id which is incidentally is the primary key for these tables.

We've also checked up to find the ODBC settings in Windows and ensured that it is not read-only.

 

After all this, we're still able to only view data from postgres. Can anybody please help us ??

 

Thanks,

 

Murali

 

Differentiated Software Solutions Pvt. Ltd.
176, Ground Floor, 6th Main,
2nd Block, RT Nagar
Bangalore - 560032
Phone : 91 80 3431470
www.diffs-india.com

> Re: Read-only tables/recordsets in Access

(1) Have you tried using psql on the Win32 machine? This will let us
know
whether your permissions are correct for editing from the other
machine.

(2) Have you tried using another ODBC client (such as MS Query)?
This will let us know whether its Access v ODBC.

(3) Are you sure that Access is properly recognizing your primary
key? (check the table design if unsure.) No primary key = No
updating of records.

(4) Do you have the READ ONLY option in the ODBC data source
turned off? The default is to leave it on. Check in *both* places in
the data source. (If you examine the table properties for the linked
table, you can see the Connect string, which will show READONLY=0
or 1 for this setting.)

--

There is a draft of a FAQ for PostgreSQL + Access at
www.scw.org/pgaccess. This may be helpful for other questions.


P.S. This question is better suited for the psql-interface mailing list,
which covers ODBC and other interfaces.
--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)