Long filenames presented via Access DB do not work

I wonder if anybody can help me. I have an access database which displays
records on a FP2003 form with no problem, all of the fields work OK.
However I have one field which displays an image which it sources from the
image directory, this works fine. I've recently experimented with moving
the images on to a shared drive and using a share in the database to access
the files, this fails if the filename contains a long version. It does
however work if I use the short (8.3) version of the file name.

An example is:

images/RC/General/13FloorElevators - Easter Everywhere.jpg (works OK)

\\computername\share$\General\13FloorElevators - Easter Everywhere.jpg
(does not work)

\\computername\share$\General\13Floo~1.jpg (works OK)

I've tried adding "" and '' to the long file name version but this made no
difference. Any ideas how I can get FP2003 to read the full field name from
the access field?

Many thanks

Ian


.

Relevant Pages

  • RE: variable for path name in ODBC connection
    ... > Actually when I shortened the pathnames for posting I left too many slashes ... >> I am trying to update a spreadsheet from an access database. ... but I need to be able to dynamically alter the filename of the ...
    (microsoft.public.excel.programming)
  • Re: Resume Database and PDFs
    ... have been put in charge of creating an MS Access database for the Resume's my ... it's best NOT to store graphical images in ... path and filename in a Text or Hyperlink field in your table. ...
    (microsoft.public.access.formscoding)
  • Creating table in Access using C#
    ... Document.MailMerge.OpenDatasource's filename to a text (tab spe.) file. ... Access database instead. ... change the table that i used as the MailMerge datasource table. ...
    (microsoft.public.dotnet.framework.adonet)
  • VBA or VBScript to extract filename from a long file path.
    ... I have an access database with a single table and several thousand records ... The file names are variable lengths but ... I want to extract only the file name in each record. ... or copy just the filename to another text ...
    (microsoft.public.scripting.vbscript)
  • Re: How do I copy a word figure and save it as a file?
    ... folder, the name of which will be the same as the filename of the document. ... Doug Robbins - Word MVP ... >I have a word document which I am capturing into an Access database. ...
    (microsoft.public.word.newusers)