Linking a DBF file with a filename longer than 8 characters

Posted on 2006-03-22
Last Modified: 2013-11-24
I noticed that there has been a soloution to this posted which says do the following:


change the SupportsLongNames reg value from 00 to 01.

I have done this and rebooted my machine, and I still get the error message:

"The Microsoft Jet database engine could not find the object '2006 03 21 0000 AndonTakt (Float).DBF'. Make sure the object exists and that you spell its name and the path correctly."

Is there a soloution to this BTW running Access2003 on an xp pro machine.
Question by:eptdsadmin
    1 Comment
    LVL 7

    Accepted Solution


    as far as I know, this is a known issue with MS Access (always has been).
    No official patch is available to change this, although occasionally some people with different OS versions were able to import those files.
    Specification says, to import a DBase file into MS Access it has to be in 8.3 filename format.
    You will have to write some code that changes the filename before importing the data.



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now