I am developing an application in VB using ADO and Access as a back-end. It has a data entry form with required and unrequired fields. I will be migrating to SQL 2000 at a later date. Should I allow null values to be saved in my tables when a user doesn’t fill out an unrequired field or should I create defaults of some kind for each data type to be saved in those cases to act as space fillers, so to speak? Thanks!
