• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 686
  • Last Modified:

Linking a DBF file with a filename longer than 8 characters

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.
0
eptdsadmin
Asked:
eptdsadmin
1 Solution
 
IT-SchubertzCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now