Store varchar(500) in Access

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?

Answer 1

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.

Answer 2

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? 

Answer 3

User733208215 posted

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

Answer 4

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.