Best way to store long filenames/paths

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe Holzhauer - 19 Aug 2005 01:32 GMT

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

Reply to this Message

SuzyQ - 24 Aug 2005 23:31 GMT

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

> 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

Reply to this Message