> Alan, > > Donot store anything in GeneralFields, and if you must than donot.
I don't. The original questioner did. > Just store the fullpath in of the .doc .xls or whatever file in your memo > field. I generally store a relative path beneath a defined root location and retrieve files when needed as root location + relative path. Storing a full UNC path or (shudder) path with a drive letter is a bad idea because you'll have to re-path everything when the server changes or the data\external files are otherwise moved, or file shares change. If you do it the way described above you only have to change the root location definition in one place. -- Alan Bourke alanpbourke (at) fastmail (dot) fm _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1469540819.1424102.677168713.53f3b...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.