Text field and file path

[B.Feldman]

Hi,
what is the maximum length of file path in Windows XP? Is it greater than
256 symbols, now? And if it's really so, have save file path in Access's
fields.

Boris Feldman

 

[Douglas J. Steele]

According to
http://msdn.microsoft.com/library/en-us/fileio/fs/naming_a_file.asp "In the
Windows API, the maximum length for a path is MAX_PATH, which is defined as
260 characters."

To store longer than 255 characters in Access, use a Memo field. (You won't
be able to index the field, though, if that's a consideration)