Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    circumvent 8.3 DBF names? (A2003)

    Is there any workaround for the 8.3 filename limitation for linking to .DBF files? (other than renaming the file!)
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: circumvent 8.3 DBF names? (A2003)

    Not as far as I know - it appears to be hard-coded!

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: circumvent 8.3 DBF names? (A2003)

    Yeah, I was afraid of that. Usually I can work around it, but in this particular case the file is already used by some other processes, and renaming would be a PITA. Drat.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: circumvent 8.3 DBF names? (A2003)

    Depending on the OS of the PC where the file is located, it may have a pseudo 8.3 file name that you could use. If you open a command window and do the DIR command, it may show it to you. The other option would be to copy the file on a regular basis (assuming that is is being updated from another system) and rename it to the 8.3 standard - ugly approach of course.
    Wendell

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: circumvent 8.3 DBF names? (A2003)

    Short filenames... great idea, but no joy. They are not present in the folder under Vista or XPPro. Is there a way to force them to be created? I could not find anything after a few minutes of Googling.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: circumvent 8.3 DBF names? (A2003)

    If you open a command prompt window and use DIR to display the list of files with the /X switch, you'll see the 8.3 names, e,g,

    dir c:databases /x

    Here is an extract of a directory listing without /X:

    FileDialogs.mdb
    FileOpen97.zip
    FileOpenDialog.mdb
    FileOpenXP.mdb
    Fill Listbox.mdb
    FixedLinesReport.mdb
    FontAndColorDialogs.mdb

    and the same with the /X switch:

    FILEDI~1.MDB
    FILEOP~1.ZIP
    FILEOP~1.MDB
    FILEOP~2.MDB
    FILLLI~1.MDB
    FIXEDL~1.MDB
    FONTAN~1.MDB

  7. #7
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: circumvent 8.3 DBF names? (A2003)

    Great catch Hans! I was a little dubious that it would work on NTFS file systems under Vista or Win2003 server, but it works like a champ! <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    Wendell

  8. #8
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: circumvent 8.3 DBF names? (A2003)

    Hans and Wendell

    Woo hoo!!! Once again, you guys amaze me with the depth of your knowledge and willingness to help. I've been putting up with this stupid limitation of Access for as long as I've been using ESRI shapefiles. My solution has always been to rename the shapefiles with 8.3 names. Now, with this little trick, I can use long filenames for the shapefiles, and simply link Access to the "hidden" shortfilename. It's such an easy and (dare I say it!) elegant solution. Done in the true spirit of a workaround!

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •