Re: Using PostgreSQL and Access?

I've been using an MS Access front-end with Postgres on Digital Unix,
Redhat and Mandrake with fairly good results. We started on v6.5.3 and
just upgraded to 7.1.3.

I download the ODBC driver from odbc.postgresql.org and haven't had any
problems. The duplicate error could possibly because Access cannot
identify a unique record. A 'many' table in a one to many relationship
could cause this problem if the foreign key is 'keyed' rather than a unique
key (which I implement similar to Access' auto number). You may want to
show the OID column (Advanced Settings).

If you would like, I have prepared an 'ODBC installation manual' that I
have in PDF format that contains graphics/screenshots for the individual
settings. Please contact me directly if you would like to obtain this
file.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Kevin Drewiske '01 CE
MSOE Webmaster Team: http://www.msoe.edu/
KJDesign Website Development: http://www.drewiske.com/KJDesign/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

-----Original Message-----
From: Markus Meyer [SMTP:meyer(at)mesw(dot)de]
Sent: Wednesday, October 24, 2001 18:29
To: PostgreSQL (General) Mailing List
Subject: Using PostgreSQL and Access?

Since the PostgreSQL (CygWin) mailing list seems to be quite dead, I'm
posting this one here.

My question is: Has any one successfully used PostgreSQL with Access? I
have
read the Accces-FAQ, but I still have major problems: When I create a form
and change / add some data in there, I always get errors, f.e. "Cannot add
duplicate index" (although I did just a minor change), but also other error
messages, or data conversion errors ("Cannot convert XID to int4"). The
error messages change, if I try other settings in ODBC driver, but it
doesn't work either. Also I get the error messages about the unique index
when I add a new record as described in the ODBC FAQ, but I don't agree
with
the "workaround" by using a timestamp. That one is really weird, and it
really should work without.

Maybe PostgreSQL (or the ODBC driver) should have a "compatibility" mode to
work with more forgiving frontends. I don't see, why f.e. a boolean column
gives an error, if you do something like "boolean_col = 0".

Access does work well with other databases over ODBC (okay, SQL Server
works, but also MySQL), so why doesn't PostgreSQL?

Regards

Markus

----------------------------------------------------
Sign Up for NetZero Platinum Today
Only $9.95 per month!
http://my.netzero.net/s/signup?r=platinum&refcd=PT97