Re: Linking a dbf file with a filename longer than 8 characters

Windows normally has both a long name and a short name
associated with each file. You can see the shortnames
at the cmd prompt by using DIR /x

If you are using code to re-link, you can use the windows
api to look up the short name for each file:

Declare Function GetShortPathName Lib "kernel32" _
Alias "GetShortPathNameA" (ByVal lpszLongPath As String, _
ByVal lpszShortPath As String, ByVal cchBuffer As Long) As Long


(david)


"Jean-Guy" <Jean-Guy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D8047739-059B-401D-AA1B-0108CE3D9190@xxxxxxxxxxxxxxxx
>I have several dbf files that Iâ??d like to link into MS Access 2000 that
>have
> filenames longer than eight characters. Access by default doesnâ??t allow
> dbf
> filenames longer than eight characters. I really need to keep my dbf
> filenames the way they are right now (i.e. longer than eight characters
> long). Is there a way around this problem?
>
> Jean-Guy
>


.

Relevant Pages

  • Linking a dbf file with a filename longer than 8 characters
    ... filenames longer than eight characters. ... I really need to keep my dbf ... Prev by Date: ...
    (microsoft.public.access.externaldata)
  • Re: Invalid argument - importing dbf from shp-file
    ... Use the old DOS 8.3 file name convention. ... Also be sure the column names in the file are 10 characters or less. ... I'm trying to figure out what's different about this shp or dbf. ... to rename all the 7 files of the shp-file is built up of. ...
    (microsoft.public.access.externaldata)
  • Re: Dbase III field attributes
    ... > What is the largest text or character field attribute in DBF tables? ... > I would like to populate a field with 8000 characters. ... Andrew told you about memo fields, but you mentioned dbase III in a FoxPro ... When you USE a dBase dbf with a memo field, ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Creating dbf table using ADO Recordset open method
    ... I will certainly look up more details on the DBF format, ... table name specified is longer than 8 characters is will truncate to 8 ... Names so they were limited to the old Dos 8.3 format. ... Since then other version of "xBase" have appeared, ...
    (microsoft.public.data.ado)
  • Re: How to maintain text characters when converting from xls to dbf f.
    ... I'm used to working with FoxPro DBFs which have a limit of 256 characters in ... characters for field names. ... Maybe DBF IV is the same. ... The dbf format trucates my text (in addition to the column ...
    (microsoft.public.excel.misc)
Loading