Hi all,

Unfortunately, there's a FLAT Database at my work place
( : ( )... It caused performance problem untill I created
views for it.

However, now, it happened ( I have no control over.. >_<
another long story..) that the users wants to add 22
fields with Data Type bit to the FLAT Database and the
Access Form they use 24hrs (\_/). This Form does Full
Table Scan (Select * ...). I wonder with this kind of
structure if I really add 22 more binary fields on to the
FLAT Database and this Form, Would it degrade the
performance ?

It's an Access application interface with SQL 2000
Server.

Thank you so much for your advise!

Annie

I mean 22 more "bit" fields, not "binary" fields..

Thank you,

Annie

>-----Original Message-----
>Hi all,
>
> Unfortunately, there's a FLAT Database at my work place
>( : ( )... It caused performance problem untill I
created
>views for it.
>
> However, now, it happened ( I have no control over..
>_<
>another long story..) that the users wants to add 22
>fields with Data Type bit to the FLAT Database and the
>Access Form they use 24hrs (\_/). This Form does Full
>Table Scan (Select * ...). I wonder with this kind of
>structure if I really add 22 more binary fields on to the
>FLAT Database and this Form, Would it degrade the
>performance ?
>
> It's an Access application interface with SQL 2000
>Server.
>
>Thank you so much for your advise!
>
>Annie
>
>
>.
>