Access overrides default SQL bit values

[newparadigm]

When I create a new record in a table with bit values in, these bit values
automatically set themselves to true, even though the default is false (0).
This only happens when I start to add data to the record, unlike the default
values which are displayed even before anything is entered.
A strange twist to this is that this only happens on two of the three
computers I tried it on, even though they are all opening the same project
(.adp) file using the same SQL Server (MSDE) database and all using Access
2003. The third computer retains the default value when a new record is added
(as expected).
Has anyone got any idea why this might be and how to stop it?
The computer that works as expected is running XP Home (as opposed to
Professional on the other two), is much lower spec. and probably hasn't been
updated as recently as the other two.

 

[Sylvain Lafontaine]

See http://support.microsoft.com/kb/945674 . Also, make sure that each
machine has its own copy of the file and make a double decompilation when
you copy the adp project from another machine before using it.

 

[Sylvain Lafontaine]

Also, the official newsgroup for ADP is m.p.access.adp.sqlserver.