• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 683
  • 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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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