Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 13th, 2005, 08:23 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default Linking DBF Data Failure

Here's a weird situation. My MDB (Access XP) links to a dBase III file (DBF). If I try to link to the file as is, that is mi_stat_rev_void.dbf, then I get this error:

"The Microsoft Jet database engine could not find the object 'mi_stat_rev_void.dbf'. Make sure the object exists and that you spell its name and the path name correctly."

However, if I shorten the file name to mi_stat.dbf then the link is successful. I'm trying to avoid having to do this extra renaming step every time I want to get updated data. The DBF file names are not under my control so I cannot just make sure the DBF gets the short name to begin with.

Any clues? Thanks in advance.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division
Reply With Quote
  #2 (permalink)  
Old April 13th, 2005, 08:51 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

Strange. Maybe you can link to its 8.3 format name instead, it will be something like mi_sta~1.dbf, you can find out exactly what it is by using "dir /x" from the DOS prompt.

hth
Phil
Reply With Quote
  #3 (permalink)  
Old April 13th, 2005, 09:31 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Yes, that worked. I was able to link to it using its DOS 8.3 filename format. That's definitely a bug in Access. Thanks!


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote
  #4 (permalink)  
Old April 14th, 2005, 04:47 AM
Friend of Wrox
 
Join Date: Nov 2004
Location: Seattle, WA, .
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post
Default

Actually, to be precise, if it is a bug, then it is a bug in "Jet" not "Access". As the guys at Microsoft like to tell me, Access is just a UI that uses Jet and whatever capabilities it has. Of course if you can set up a DSN in Data Sources using the dBase File driver on the long file name, then the problem is actually that Access doesn't interface with the driver correctly.

I have heard that performance over a network is better if you link only to the 8.3 file name format. Maybe this has something to do with how Jet was written.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org
Reply With Quote
  #5 (permalink)  
Old April 3rd, 2008, 04:09 AM
Registered User
 
Join Date: Apr 2008
Location: , , Austria.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank god i found this post, I spent half of yesterday to figure out why I could'nt link to some dbf files (unfortunately i'm not able to just rename them...)
strange thing is, that my colleague at work is using the same system and office set up (xp sp3 and office 2003 sp3) and everything works just fine on her machine.
Finally tried to link to the DOS 8.3 filename today, and now it works ...
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fetch data from DBF to SQL arty125 VB.NET 1 August 20th, 2007 01:06 PM
Which data provider fro dbf file format in vb kau_shuk Pro VB.NET 2002/2003 1 November 29th, 2006 08:40 PM
Transfer data from .dbf file to SQL Server 2000 somnath.kartic SQL Server 2000 1 October 18th, 2006 11:01 AM
command button to import dbf data patmolard Access VBA 1 April 21st, 2004 06:48 PM



All times are GMT -4. The time now is 12:17 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.