Microsoft Access: “Make-Table Query” Force Memo Fields

by on Oct.05, 2010, under Programming

Unfortunately it looks like there isn’t a way to force Access to make a table with Memo data type fields instead of Text.  A functional work around is:

  1. Run the Make-Table query
  2. Edit the table in Design View
  3. Change the Text field to Memo
  4. Change the Make-Table query to an Append query
  5. Create a Delete query
  6. Run the new Append query



    3 Comments for this entry

    Leave a Reply