Storing filenames/paths--the best way?

[Joe Holzhauer]

I'm wondering what data type would be best to store file pathnames. Some of
the files I'm dealing with have very long pathnames, easily exceeding the
255 character limit for Text. Will using a Memo field unnecessarily
increase disk space usage (is there a better way--perhaps using a hyperlink
field to store a simple file path)?

Thanks for your help!
Joe

 

[Guest]

Hi Joe,

I guess if you store 300-500 charatcers in a memo field woudn't increase the
database size that much. Or what you can do is have a two seprate fields, one
for the path and one for the file name, in your program you might have to
code to extract the file name and path. How are you obtaining the file path
and file name?

This is a round about soultion though and not sure how effective it would
be. In your table you can assign a integer value like 1,2,3 etc and in a text
file you can store this vaule and the file path and name, so every time you
need to fetch you fetch the numeric vaule from the table and then open the
text file read the line the that has the corresponding numeric value.
Honestly this is a very round about and is not a good solution though.
Implementing this would be time consuming.

Best would be to store the path and file name seprately.


Hope you found this helpful.

Anand


Anand

 

[John Nurick]

Hi Joe,

There's a certain amount of overhead associated with memo fields but not
enough to worry about. Since the Access/Jet Hyperlink field type is a
variant of the Memo there's no advantage there.

But don't your super-long paths give you problems with Windows software?