Hello-
I am trying to create an Access table using DDL that has a memo field.
I have the syntax to create the memo field but I can't find the syntax
to also set whether the memo field should allow zero length. I can set
this option using the Access interface directly, but I want to create
this table and this column definition using a DDL script. Listed below
is the script that works but I just need the syntax to set the
additional setting of allowing zero length.
The field in question is the instructions memo field.
The DDL script I have so far is:
CREATE TABLE Media_schedule (
Schedule_id AUTOINCREMENT constraint Primarykeyname Primary Key,
Media_type_id INT ,
Group_id INT ,
Media_id INT ,
Status INT ,
Delivery_time_encoded CHAR (10) ,
Delivery_date_sysformat datetime ,
Pickup_time_encoded CHAR (10) ,
Pickup_date_sysformat datetime ,
Customer_id CHAR (20) ,
Address CHAR (100) ,
Building CHAR (100) ,
Room CHAR (100) ,
Phone CHAR (50) ,
Instructions memo ,
Contact CHAR (100) ,
Event_description CHAR (100)
);
Thanks
Scott Vanderlip
Internet Software Sciences (http://www.inet-sciences.com)