I'm creating tables in an Access DB. Some of the fields allow nulls, but Access ignores my leaving out the NOT NULL in the create table statement and sets ''allow zero length'' to 'No'.
Someone mentioned something about how Access XP may fix this, but I have to make the tables usable to a wide audience, so I'm using 2K. Is there some SQL parm that Access understands? Can I use Access XP and maybe save to an older format? dirty but quick. ----------------------------------------- Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ----------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
