Re: Datatype conversions from SQL to Access

From: Joe Fallon (jfallon1_at_nospamtwcny.rr.com)
Date: 02/12/04 

Date: Thu, 12 Feb 2004 00:32:10 -0500

Probably because when you defined Bit you allowed Nulls so it is really a 3
way data type.
Just uncheck Allow Nulls so it is 2 way (Y/N, T/F, 1/0). 

-- 
Joe Fallon
Access MVP
"Baffee" <anonymous@discussions.microsoft.com> wrote in message
news:e09b01c3efe8$35bf5a90$a501280a@phx.gbl...
> I use SQL tables to store all my access data and then link
> to Access 2000 with and ODBC connection.  I am looking for
> a datatype in SQL that will convert to Yes/No in Access. I
> will be storing a yes/no or 0/1 to indicate whether a
> process has been completed.
>
> I have tried datatype Bit and it converts to the Yes/No
> Datatype in Access but then you can't update anything else
> in the record. When you try to make any changes to the
> Access table you get a box with the message:
> "The record has been changed by another user since you
> started editing it.  If you save the record your will
> overwrite the changes the other user made."
>
> There is an button Save Record at the bottom of the box,
> but it is grayed out and can't be chosen.
>
> Any ideas how I can get work around this problem?
>
> Thanks!