Using Microsoft Access as front end to Postgres

From: "Steve Quezadas" <steveeq2(at)tripperjones(dot)com>
To: <pgsql-general(at)hub(dot)org>
Subject: Using Microsoft Access as front end to Postgres
Date: 2000-10-05 21:38:08
Message-ID: 00f001c02f14$8e5d6270$7801a8c0@steve
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am trying to use Microsoft Access as a front end to Postgres, but I am having some trouble with the ODBC driver. I get all sorts of weird problems. For instance, sometimes when I enter in new values in a table, if the field I type in a field that has already been typed in before (ie I type "CA" in two different rows of the "states" column), the whole row has "#Deleted" in it. Other times, I want to delete a record, and I'll get a dialogue box that says "ODBC--delete on a linked table 'test' failed" and then another one that says "Error while executing the query; ERROR: Unable to identify an operator '=' for types 'xid' and 'int4'. You will have to retype this query using an explicit cast". I get the same exact errors if I try to change an item in a current record.

I assume there is a more reliable way to connect to database clients than this. Has anyone got a Microsoft Access front end working with Postgres? I am using Postgres 7.0.2 and ODBC driver postdrv 6.5.

I also tried going to OpenLink ODBC, but I can't find where you are supposed to put IP address of the server you want to connect to with this driver. the Help files are non-existant with this particular driver.

- Steve

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wade D. Oberpriller 2000-10-05 22:03:21 Good reference for PL/pgsql
Previous Message Tom Lane 2000-10-05 20:07:04 Re: Re: [SQL] Object syntax