>You could use the ShortName, not shure how to do it in VB9.0, as you already know, but it should be very simple, in FoxPro I would do this
>
>
>loFSO = CREATEOBJECT('Scripting.FileSystemObject')
>loFile = loFSO.GetFile(GETFILE())
>? loFile.ShortName
>? loFile.ShortPath
>
>
>ie:
>For
>C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v3.5\Samples\Northwind.sdf I will get
>
>C:\PROGRA~2\MI0788~1\V3.5\SAMPLES\NORTHW~1.SDF
>
>
>There is still no guarantee that it will be shorter than 260 chars but you've got more chances that it'll work
Yes, that is correct. We will not have any guarantee that that will always work assuming similar long file names and such.
Thanks for having responded.