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

ODBC and Access 2000

From: Chris Gray <cpgray(at)library(dot)uwaterloo(dot)ca>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC and Access 2000
Date: 2001-05-07 18:09:40
Message-ID: Pine.SOL.4.21.0105071346240.28008-100000@library.uwaterloo.ca (view raw or flat)
Thread:
Lists: pgsql-odbc
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?

Thanks,
Chris



Responses

pgsql-odbc by date

Next:From: Luke MahonyDate: 2001-05-07 19:49:52
Subject: Postgresql driver needed
Previous:From: Tom.BakkenDate: 2001-05-07 16:02:17
Subject: core and temp files

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