Re: Using Microsoft Access as front end to Postgres

One thing to be sure of is that the postgres tables all have a unique id # and that you tell OBDC what field it is when you connect from msaccess.

Tim McKenna

*********** REPLY SEPARATOR ***********

On 10/5/00 at 2:38 PM Steve Quezadas wrote:
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