Tag: microsoft access

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 : more...

    Access—you suck!

    by on Sep.24, 2010, under Tumblr

    Access—you suck!

    Leave a Comment :, more...