Some troubles with Access and bool

From: Jean-Max Reymond <jmreymond(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Some troubles with Access and bool
Date: 2004-10-12 20:27:47
Message-ID: 4b09a0c0410121327685b5327@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I have a small table in my 7.4 Postgres database:

CREATE TABLE jmbool
(
icompt int4,
mybool bool
)
WITHOUT OIDS;

I have MS Access 2003. My ODBC Driver a the option "treats bool as
char" unchecked.
IN MS Access, I can add a record but it not possible to delete any record:
error message: The Microsoft Jet database engine stopped the process
because you and another user are attempting to change the same data at
the same time.

Of course, I am alone on the Postgres database.
How to solve this blocking issue ?
Thanks for your answers.

--
Jean-Max Reymond
CKR Solutions
http://www.ckr-solutions.com

Browse pgsql-odbc by date

  From Date Subject
Next Message Jean-Max Reymond 2004-10-12 20:32:55 Some troubles with Access and bool
Previous Message Ben Suffolk 2004-10-12 16:20:50 Can't connect with ODBC on FreeBSD