Linking a dbf file with a filename longer than 8 characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Back
Top