locked
Store varchar(500) in Access RRS feed

  • Question

  • User733208215 posted

    Hi,

    I want to set a text with max length 500 in Access Table. It can be done in MSSQL Server easily with varchar(500). However, Access cannot. I set it to memo but memo cannot be used to join other table. Since this field is key and will be used to join other table, I want to find out a method to solve this problem.

    How can I join the memo or set the text to 500 max length?

    Wednesday, April 10, 2013 12:28 AM

Answers

  • User-1360095595 posted

    Personally I wouldn't use filename as a primary key. I'd use an auto increment id column (or maybe guid) and use those for the join. Having said that I'm not that familiar with Access. 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, April 10, 2013 7:01 AM

All replies

  • User-821857111 posted

    How can I join the memo or set the text to 500 max length?

    You can't. That's a limitation of Access.

    Wednesday, April 10, 2013 1:09 AM
  • User-1360095595 posted

    Why are you joining tables on a varchar(500) field? Don't you have simple ID columns in your tables for joining? 

    Wednesday, April 10, 2013 1:31 AM
  • User733208215 posted

    Since in these tables, we use filename as primary key. However, when we use full path, it may exceed 255 character.

    Wednesday, April 10, 2013 4:48 AM
  • User-1360095595 posted

    Personally I wouldn't use filename as a primary key. I'd use an auto increment id column (or maybe guid) and use those for the join. Having said that I'm not that familiar with Access. 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, April 10, 2013 7:01 AM