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(at)vectormath(dot)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(at)email(dot)com>
> To: pgsql-general(at)postgresql(dot)org <pgsql-general(at)postgresql(dot)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