Skip site navigation (1) Skip section navigation (2)

Re: ODBC and Access 2000

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Chris Gray <cpgray(at)library(dot)uwaterloo(dot)ca>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC and Access 2000
Date: 2001-05-08 00:19:09
Message-ID: 3AF73B7D.31996409@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Chris Gray wrote:
> 
> I'm running PostgreSQL on a Debian GNU/Linux box and have installed
> pgAdmin successfully on a Windows 98 machine.  pgAdmin works fine for
> updating tables.  I can use Access 2000 to insert a new row in a table.
> If I create an Access SQL query to update or delete a row, it works.
> 
> If I try to delete or update a row using the data sheet view of a linked
> table I get a "write conflict" error or a message from the Jet db engine
> that another user is trying to modify the same data even though I'm the
> only one connected to the database.
> 
> Any idea what's going on and how to stop it?
> 

Which version of psqlodbc driver are you using ?
If it's older than 7.01.0003 please try the latest one.

regards,
Hiroshi Inoue

In response to

Responses

pgsql-odbc by date

Next:From: Peter WilkinsonDate: 2001-05-08 06:13:33
Subject: RE: ODBC and Access 2000
Previous:From: Bruce MomjianDate: 2001-05-07 23:54:26
Subject: Re: ODBC cleanup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group