Re: PostgreSQL, ODBC, Access

Agreed.  And i think Access and/or the ODBC driver may be doing
something like this behind the scenes, but i don't know how i'd verify.
However, she is entering data directly into the table "datasheet" (as
Access calls it).  This brings another (newbie) question:  how do i
query PG to find out how many users are connected & what they're doing?

Thanks,

Jeff

davidb@vectormath.com wrote:
>
> 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