By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,208 Members | 1,202 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,208 IT Pros & Developers. It's quick & easy.

Help with setting Access Memo field restrictions using DDL

P: n/a

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)


Scott Vanderlip
Internet Software Sciences (

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.