Long filenames presented via Access DB do not work

I

Ian

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
 
S

Stefan B Rusynko

You problem is not the length of the file name but the spaces in it
If you can't remove the spaces from the file names (recommended),
try adding the explicit space encoding (%20) to your DB link
\computername\share$\General\13FloorElevators%20-%20Easter%20Everywhere.jpg




|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
|
|
 
I

Ian

Thanks for the reply, I found another solution. I changed the request
string to include the computer and share name. The DB field only contains
the file name (in full) and this seems to have done the trick.

Ian
 
Top