Thread: Some troubles with Access and bool

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

DSN ODBC Driver options
Page 2 - check row versioning

Jean-Max Reymond wrote:

>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.
>
>
>
>
>

On Wed, 13 Oct 2004 09:17:13 -0400, Greg Campbell
<greg.campbell@us.michelin.com> wrote:
> DSN ODBC Driver options
> Page 2 - check row versioning

now, it is checked but same issue.
I have set the driver trace  on but not helpful for me :-(

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

On Thu, 14 Oct 2004 04:04:27 +0200, Jean-Max Reymond
<jmreymond@gmail.com> wrote:
> On Wed, 13 Oct 2004 09:17:13 -0400, Greg Campbell
> <greg.campbell@us.michelin.com> wrote:
> > DSN ODBC Driver options
> > Page 2 - check row versioning
>
> now, it is checked but same issue.
> I have set the driver trace  on but not helpful for me :-(

Yeah, my problem is solved :-)
With the help of the odbc file log, I have got the request sent to the
Postgres database.
So, the request is:
DELETE from jmbool where  icompt=23 and mybool='0';
but unfortunatly, value of mybool was null and not false because never
initalized.

Access read a value null for a bool type and interprets as false.
the DELETE was denied because not succesfull and Acess says that
another user has changed the record !!!!
Now, the field myboll has a default value as false, all the database
is upgraded  and all works fine :-)

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