Home Forums Programming General Yes/No field in sql server table what is the same RE: Yes/No field in sql server table what is the same

  • for BIT value :

    True = 1 (in SQL Server)

    True = -1 (in Access db)

    false = 0 for the two system

    ( so when you link, Access Automatically [internally] convert 1 to -1, and when you save it the ODBC convert

    -1 to 1 .. (or it just a display convert))

    I hope this help u

    Alamir Mohamed


    Alamir Mohamed
    Alamir_mohamed@yahoo.com