[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

linking DBF with filename size greater than 8 characters in Access

Posted on 2006-03-27
13
Medium Priority
?
2,167 Views
Last Modified: 2008-01-09
Hi there,
I get the following error message when trying to link or import a DBF file in Access with a name greater than 8 filename length.
   "The Microsoft Jet database engine could not find the object filename. Make sure the object exists and that you spell its name and the path name correctly."

I found this technical note on Microsofts website and it says that although this was not the case previously "changes to Jet security now require that you use the correct extension" - 8.3
http://support.microsoft.com/kb/209685/en-us

Is there anyone out there that has found a work around to this? Can I remove the new Jet engine that is installed and revert to the old one where I know it used to let me link/import dbf files with a name greatert than 8 characters?

Thanks for your help.
0
Comment
Question by:cmcgregor
13 Comments
 
LVL 26

Expert Comment

by:jerryb30
ID: 16301266
It sems you might be able to programmatically either rename the file when the name does not follow the 8.3 convention, or copy the file, giving it a suitable name.
Doesn't answer the engine question, I know, but is a possible workaround.
0
 

Author Comment

by:cmcgregor
ID: 16301394
Yes  it says that in the MS Article and that is what I have to do now is change the length to 8. I do not need a program to change the filename as I am manually linking it each time. I use FoxPro as well so I go back and forth from foxPro to Access depending on what I need to do and I prefer to have a name longer than 8 characters
0
 
LVL 39

Expert Comment

by:thenelson
ID: 16307572
You could try the DOS name of a windows long name which is the first 6 characters minus any spaces, a tilde (~) and a number for duplicates.  The extension would be the first 3 characters minus spaces.  For example:
my text file.text = mytext~1.tex
my text file number two.text = mytext~2.tex
If the two files are in the same folder and "my text file.text" is the first file listed in the unsorted directory listing.
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 

Author Comment

by:cmcgregor
ID: 16309538
Thanks for the suggestion however I would like to have names that are meaningful like File1Day58.dbf. Shortening them makes it more difficult to decifer between files
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 16458126
cmcgregor,

Importing:
Another option would be to import the DBF file to Excel first. Then change the name of the sheet tab to match the original DBF filename. Then import the Excel File into Access. The resulting Access Table will retain the Excel sheet tab name by default.

Linking:
Change the name of the DBF file to match the 8.3 convention. Then Link as normal. Then simply rename the linked file to the original DBF filename.

Keep in mind also that even if you have short names for objects in the Access database window, you can right click the table (Or any object for that matter) and choose "properties". In the description box you can type in description as long as you like. Then when the Database window is in "Details" view you will see the description.

Hope this helps as well
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 16458142
Sorry,

When you inport the DBF file into Excel, it should create a sheet tab that retains the DBF File name.

good luck
0
 

Author Comment

by:cmcgregor
ID: 16462258
Thanks for the suggestion but I repeatr I would like to have names that are meaningful like File1Day58.dbf. Shortening them makes it more difficult to decifer between files. I do not want to have to pass files between Excel and Access. I was aware I could do this already.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 16468203
OK,

Here is an Microsoft link claiming that you can heve Jet  3.5 and 4.0 Apps that co-exist
http://support.microsoft.com/kb/244040/EN-US/

Check the DBase site and see if they have an updated driver, that would allow filenames longer than the 8.3 limit?

A few more links:
http://www.albionresearch.com/misc/obscurities.php
http://support.microsoft.com/kb/307455/EN-US/
http://support.microsoft.com/?kbid=263561
http://support.microsoft.com/kb/230125/EN-US/

Give them a look.

I hesitate to say "It can't be done"... but this MS link has this to say about un-installing Jet 4.0
<How to Uninstall...>
<Uninstall is not available.>
http://www.microsoft.com/WINDOWS2000/downloads/recommended/q282010/default.asp

The update claims to fix security vunerabilities so you may be stuck here.

Let's see if anyone else knows of a workaround.
0
 

Expert Comment

by:bear61mtr
ID: 16528427
You can find the short name which can be used to access the file as well as the long name  by running the command dir /x.  You can then link to this short name in Access and still use the long name also.
0
 
LVL 27

Expert Comment

by:jjafferr
ID: 16787901
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
    PAQ with points refunded

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

jjafferr
EE Cleanup Volunteer
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 16788028
fine by me
0
 

Author Comment

by:cmcgregor
ID: 16800638
Fine by me as well.
0
 

Accepted Solution

by:
CetusMOD earned 0 total points
ID: 16822358
PAQed with points refunded (250)

CetusMOD
Community Support Moderator
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

865 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