We help IT Professionals succeed at work.

Linking a DBF file with a filename longer than 8 characters

Medium Priority
697 Views
Last Modified: 2013-11-24
I noticed that there has been a soloution to this posted which says do the following:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\ISAM Formats\dBase IV

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.
Comment
Watch Question

Hi,

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.

HTH

Andy

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.