Re: Long filenames presented via Access DB do not work



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

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"Ian" <ianmiller109@xxxxxxxxxxx> wrote in message news:uJNaokduFHA.2624@xxxxxxxxxxxxxxxxxxxxxxx
|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: Calendar Interface
    ... To find the best Newsgroup for FrontPage support see: ... |I have an Access database that people submit events to. ... It must be really simple to do (I know a little ASP programming, ...
    (microsoft.public.frontpage.programming)
  • Re: Publishing a Form
    ... But you can use the access database with a FP HTML/ASP form ... To find the best Newsgroup for FrontPage support see: ...
    (microsoft.public.frontpage.client)
  • Re: Problems with Access after Publishing
    ... You need to provide info on the differences in the queries ... To find the best Newsgroup for FrontPage support see: ... | I have a small site that has an Access database in it. ...
    (microsoft.public.frontpage.programming)
  • Re: Problems with Database after publishing
    ... Hard for anyone to help w/o knowing more about the queries ... To find the best Newsgroup for FrontPage support see: ... | I have a small site that has an Access database in it. ...
    (microsoft.public.frontpage.extensions.windowsnt)
  • Re: Determine Data Source
    ... Please reply to the newsgroup unless you wish to avail yourself of my ... Applications/Office 2003 Applications/Microsoft Office Word 2003 ... When I click the 'Open Data Source' command button on the Mail Merge ... there any way to determine which Access database the Word document is ...
    (microsoft.public.word.mailmerge.fields)

Loading