|
|
 |
| 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 .
|
 |
|
|
 |
April 13th, 2005, 08:23 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
|
|
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
|
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
|
|
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
|
April 13th, 2005, 09:31 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
|
|
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
|
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
|
|
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 |
April 3rd, 2008, 04:09 AM
|
|
Registered User
|
|
Join Date: Apr 2008
Location: , , Austria.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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 ...
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
