Re: PostgreSQL, ODBC, Access

Hi Jeffrey,

If you open a form that is bound to a table (or bound to a query that is
bound to a table) that is one database connection.  If you then script
database updates from the form
(e.g.:
Dim dbs As Database
Set dbs=CurrentDB
dbs.Execute("UPDATE tbl_blah SET szBlah = 'blah' WHERE nBlahID = 5")
)
then you are opening a second database connection.  This is seen by Access
as two users accessing the same record.  I don't know if this is your
problem, but it will cause your symptoms.

David Boerwinkle

-----Original Message-----
From: Jeffrey A. Rhines <jrhines@email.com>
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Date: Monday, July 24, 2000 11:21 AM
Subject: [GENERAL] PostgreSQL, ODBC, Access


Hello All,

Here's a bothersome issue:  I've got the most recent versions of
Postgres, ODBC client for Win32, and Access 97.  My client can enter new
records fine via a linked table.  However, when she goes back to add
data to a column, she gets the following error:

message box title: "Write Conflict"
description: "This record has been changed by another user since you
started editing it.  If you save the record, you will overwrite the
changes the other user made."
buttons: "Copy to Clipboard" and "Drop Changes".

She is the only person using the database at the time.  The column type
doesn't matter, either.  Does anyone know what causes this?

Best Regards,
Jeff Rhines