error 3290 Syntax error in Create table statement

[dogdays]

When I try to execute the following I get the above error:

<!--[if gte mso 9]><xml>  <w:WordDocument>   <w:View>Normal</w:View>   <w:Zoom>0</w:Zoom>   <w:PunctuationKerning/>   <w:ValidateAgainstSchemas/>   <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>   <w:IgnoreMixedContent>false</w:IgnoreMixedContent>   <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>   <w:Compatibility>    <w:BreakWrappedTables/>    <w:SnapToGridInCell/>    <w:WrapTextWithPunct/>    <w:UseAsianBreakRules/>    <w:DontGrowAutofit/>   </w:Compatibility>   <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>  </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml>  <w:LatentStyles DefLockedState="false" LatentStyleCount="156">  </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style>  /* Style Definitions */  table.MsoNormalTable     {mso-style-name:"Table Normal";     mso-tstyle-rowband-size:0;     mso-tstyle-colband-size:0;     mso-style-noshow:yes;     mso-style-parent:"";     mso-padding-alt:0in 5.4pt 0in 5.4pt;     mso-para-margin:0in;     mso-para-margin-bottom:.0001pt;     mso-pagination:widow-orphan;     font-size:10.0pt;     font-family:"Times New Roman";     mso-ansi-language:#0400;     mso-fareast-language:#0400;     mso-bidi-language:#0400;} </style> <![endif]-->  CREATE TABLE tblTemplatePatronInterLibraryRequestsLabelsj (nIdentity  Long,  nHouseholdNumber Long,
  nIndividualNumber Long,
  tStatus Text(1),
  bInState YesNo,
  tInstitutionCode Text(10),
  nRelationshipType Byte,
  tRequestID Text(50),
  dtRequested DateTime,
  tStaffInitials Text(50),
  dtRequestSentToILLS DateTime,
  dtReceivedFromILLS DateTime,
  dtPatronNotified DateTime,
  dtScheduledILLSReturn DateTime,
  dtReceivedByPatron DateTime,
  dtScheduledPatronReturn DateTime,
  dtActualPatronReturn DateTime,
  dtActualILLSReturn DateTime,
  tTitle Text(50),
  tFirstName Text(50),
  tMiddleName Text(50),
  tLastName Text(50),
  tSuffix Text(50),
  tAddressLine1 Text(50),
  tAddressLine2 Text(50),
  tAddressLine3 Text(50),
  tCity Text(50),
  tState Text(50),
  tPostcode Text(50),
  tBookTitle Text(50),
  tAuthorLastName Text(50),
  tAuthorFirstName Text(50),
  tYearPublished Text(50),
  tPublisher Text(50),
  tJournalTitle Text(50),
  tIssue Text(50),
  tNumber Text(50),
  tPages Text(50),
  nContactType Byte,
  tContact Text(50),
  tAuthorFullName Text(50),
  tPatronFullName Text(50),
  mComments Memo(50))

Have googled the problem to death with no joy.
Jack

 

[Norie]

Jack

Memo fields have no size.

Change the last field type from Memo(50) to Memo.

 

[dogdays]

Norie:
Thank you, works well.

Jack