SLeepdepD

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
1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...Loading...
    :

    3 Comments for this entry

    Leave a Reply