Linking a dbf file with a filename longer than 8 characters

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
 
D

david epsom dot com dot au

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top