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:32:55
Message-ID: 4b09a0c04101213324a920471@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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Greg Campbell 2004-10-13 13:17:13 Re: [Maybe Spam] Some troubles with Access and bool
Previous Message Jean-Max Reymond 2004-10-12 20:27:47 Some troubles with Access and bool