Thread: 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
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
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
Greetings! I have seen similar (too often for my liking) while trying to update data directly in a linked table/datasheet via MSAccess ... I've tried to work out why, and it just isn't logical (while changing a set of contiguous, related records, some will come up with this error, some won't) ... However, if I use an (Access) update query, or do it in VisualBasic, it works fine. Note that this problem occours with other SQL Servers (including MS SQL), so it's not the fault of the server. Basically, don't use datasheets - MSAccess / ODBC does something odd with the locking. Dave Burbidge Network Administrator > -----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