Best way to store long filenames/paths

  • Thread starter Thread starter Joe Holzhauer
  • Start date Start date
J

Joe Holzhauer

I'm storing some fairly long filenames/paths in a table (they easily exceed
the 255 character limit for Text fields). Does using a Memo field
unnecessarily increase database size? Is there a better alternative?

Thanks for your advice,
Joe
 
This is from the "About data types and field sizes" in access help.

"Both Text and Memo data types store only the characters entered in a field;
space characters for unused positions in the field aren't stored."
 
Back
Top