More fields in an Access Form 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 |