all groups > sql server data warehouse > september 2003 >
You're in the

sql server data warehouse

group:

More fields in an Access Form



More fields in an Access Form Annie
9/12/2003 10:53:06 AM
sql server data warehouse: 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

More fields in an Access Form Annie
9/12/2003 11:00:17 AM
I mean 22 more "bit" fields, not "binary" fields..

Thank you,

Annie

[quoted text, click to view]
AddThis Social Bookmark Button