Link SQL Server 2000 and Bit Type

[sck10]

Hello,

I have two views in SQL Server (view_DevNote, view_AutoParts). Whenever I
link to the view "view_DevNote", the Bit fields convert to the "yes/no" data
type in Access. However, I can't seem to get the other table
"view_AutoParts" to behave the same way. The Bit field always shows up as a
data type of "Number".

Also, I noticed that when I go into the design view for "view_DevNote", the
following fields are absent from General Tab (Field Size, Input Mask, Allow
Zero Length and Unicode Compression). But these fields are not missing in
the design view of "view_AutoParts".

Any help with this would be greatly appreciated...

--
Thanks in advance,

sck10


Link SQL Server 2000 and Bit Type

 

[SJ]

look at the finer field properties in EM or do a "select into" from the
view to see what datatype is being produced, access won't be causing the
error... The view might be changing the base datatype...

sorry it's brief but the last post didn't make it.