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."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Storing filenames/paths--the best way? 2
Image ctl causes bloat when using text field to store path/filenam 13
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Text Field Size - Access 2007 2
memo field 7
corruption and memo fields 3
Table field length limit alternative 8
path too long solution 1

Back
Top