Re: Long filenames presented via Access DB do not work

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

"Stefan B Rusynko" <sbr_enjoy@xxxxxxxxxxx> wrote in message
news:uY91NVeuFHA.3188@xxxxxxxxxxxxxxxxxxxxxxx
> 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: Send Message to filemaker 5.5 from windows form application
    ... Script created by Steve Carson and it was modified by Kristina ... ' Chrto represent double quotes if you are passing a string. ... Dim pHyperlink As IHyperlink ... 'opens Microsoft Access database ...
    (comp.databases.filemaker)
  • Re: email report per record
    ... is a couple of Access database ... Dim strSubject As String 'Email Subject ... Dim stDocName As String ...
    (microsoft.public.access.reports)
  • Network user count question
    ... an MS Access database on a network server? ... Public Function AddUser(mUserID As String, ... Dim bOK As Boolean ... Dim obj As User ...
    (microsoft.public.vb.database.ado)
  • Cannot Open Any more databases
    ... records from an Access database. ... Function PopDataTable(ByVal ods As DataSet, ByVal sTable As String, ... OleDbConnection = Nothing, Optional ByVal ocomSel As OleDbCommand = ... sRelation, shChildCount) ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Amend Access database from Excel
    ... The code below uses ADO to connect to the Access database. ... The query string ... Dim oConn As ADODB.Connection ... Set oConn = New ADODB.Connection ...
    (microsoft.public.excel.programming)