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.
Michigan Dept. of Environmental Quality, Air Quality Division