Charlotte Foust
cfoust at infostatsystems.com
Thu Jul 31 19:46:20 CDT 2008
No we don't do it at the table level, we handle it through UI and data tier means. That way, if some genius goes in an changes the field setting (yes, our client admins have access, and they're the DBAs), our app won't break. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Thursday, July 31, 2008 12:47 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Access Upsizing Charlotte, You said that you check for =0 or <>0, rather than check for True or False. Do you set Allow Nulls = False in the table design for those bit fields which represent a True/False condition? Dan -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com