The one that I found in upgrading is that the Yes/No has to translate to the smallint (not bit) if you are front-ending with Access 97. It may have changed in Acc2K. But the values for boolean field are 0 and -1. The bit is 0 to 255 with no negatives.