>This might be a little off topic: I am wondering if anyone knows how to
>specify field properties when using the Create TABLE or Alter TABLE SQL
>statements in MS Access. I am writing some code to create a few tables on
>the fly, and it would be very handy to be able to specify things like
>"required" and "Allow Zero Length strings", etc... when creating the tables
>or altering them.
You should check out Jose's guide to using Jet SQL at
http://www.citilink.com/~jgarrick/vbasic/database/jetsql.html
I have a feeling that you can't set field properties such as "allow zero length"
etc using jet SQL - although I may be mistaken.
--------
Rob Keniger
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
