| | |
|
|
|
Re: using Access with SQL Server?? |
|---|
| message from david epsom dot com dot au on 7 May 2004 |
SQL Server bit fields are 3 state by default: Yes No Null
Jet 4 does not support 3 state bit fields.
When you connect Access to SQL Server, all bit fields with
value Null are translated as "false". When Jet compares
the "false" value to the original "Null" value, it reaches
the conclusion that someone else must have changed the data.
You can change all SQL Server bit fields to integer fields,
or change them so that they cannot or do not have null
values.
(david)
"Jerome" <jherr@no.mnhn.spam.lu> wrote in message
news:OW$e$YsLEHA.1484@tk2msftngp13.phx.gbl...
|
|
Archived message: Re: using Access with SQL Server?? (MS Access)
