How Do I Create a MEMO Field Using the SQL CREATE

Topic

New Reply

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?(???));

Reply | Quote

Replies

Eileen discourages cross-posting and she’ll probably put a wart on your nose for doing it. If you go back to the Access forum, you’ll find the answer posted there.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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

thanks for the help!

–llyal

Reply | Quote