Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How Do I Create a MEMO Field Using the SQL CREATE

    How Do I Create a MEMO Field Using the SQL CREATE TABLE?

    I am trying to make tables with Memo fields using the SQL CREATE TABLE statement; what do i use as the key word? I know to use TEXT for text fields (up to 255 chars), but i cannot find anywhere how to create Memo fields;

    Do i need to use ADO? What is the How-To?

    Thank you!

    --llyal

    CREATE TABLE tblFriends
    (FriendID INTEGER NOT NULL,
    LastName TEXT(50) NOT NULL,
    FirstName TEXT(50) NOT NULL,
    Phone TEXT(10),
    Email TEXT(50),
    Notes MEMO?(???));

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How Do I Create a MEMO Field Using the SQL CREATE

    Eileen discourages cross-posting and she'll probably put a wart on your nose for doing it. [img]/w3timages/icons/laugh.gif[/img] If you go back to the Access forum, you'll find the answer posted there.
    Charlotte

  4. #3
    Star Lounger
    Join Date
    Jan 2001
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How Do I Create a MEMO Field Using the SQL CREATE

    I apologize,

    I would not do this if i had questions with Word or Excel; Because Access and VB are very alike, and posters do not consistently use certain newsgroups and/or post in a consistent manner, I concluded this was the best way to get my question addressed, as well as help others who will search the forums for answers in the future and do not realize that Access and VB overlap a lot;


    Here is the correct answer;

    I learned from another newsgroup that one needs to use the LONGTEXT with CREATE TABLE to make a memo field; Using MEMO (which is logical) gives errors;


    Thank you for the help!
    --llyal

  5. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How Do I Create a MEMO Field Using the SQL CREATE

    No need to apologize. It's just that most people who work with Access tend to look first in the Access forum. If you were a member of the old Lounge you would have noticed that very few of the VB/VBA postings had to do with Access/Jet.

    Your answer is very interesting because I tested the DDL statement on my machine before I posted it, and it very politely created a table with a memo field when I used the MEMO datatype. What version of Access are you using? Mine is Access 2000.
    Charlotte

  6. #5
    Star Lounger
    Join Date
    Jan 2001
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How Do I Create a MEMO Field Using the SQL CREATE

    I just tried it with the Memo in place of LongText and it worked fine, too; no explanation;

    thanks for the help!

    --llyal

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •