View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 06:11 PM
Annie
 
Posts: n/a
Default 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


Reply With Quote