Connecting Tech Pros Worldwide Help | Site Map

Help with setting Access Memo field restrictions using DDL

 
LinkBack Thread Tools Search this Thread
  #1  
Old November 13th, 2005, 02:56 PM
Scott Van
Guest
 
Posts: n/a
Default Help with setting Access Memo field restrictions using DDL

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)


 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,840 network members.