[AccessD] Access Upsizing

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




More information about the AccessD mailing list