Re: PostgreSQL, ODBC, Access
От | |
---|---|
Тема | Re: PostgreSQL, ODBC, Access |
Дата | |
Msg-id | 000c01bff594$b7401b60$0602010a@bullwinkle.vectormath обсуждение исходный текст |
Ответ на | PostgreSQL, ODBC, Access ("Jeffrey A. Rhines" <jrhines@email.com>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: