We have a MS Access database which has VBA code to link to a .dbf file
on a network drive using the following command:
DoCmd.TransferDatabase acLink, "dBase IV", txtDBPath, acTable,
ASTUTable & ".dbf", "ASTU"
Depending on the school district chosen the desired file may be located
in a folder that has a space in its name e.g. I:\Some CSD\Madison
Avenue MS\DATAFILE
Up until recently, this worked fine. Now it fails for two of the ten
or so people that use it and still works (links) fine for the other
eight people BUT it only fails for the two people when there's a space
in the somewhere in the file structure. I'm one of the two people for
whom it fails. :-( If I copy the folder name/data to my "C" drive it
works fine but if I copy it to a another network drive, it fails. Has
anyone seen something like this before? The error message is "Problem
linking ASTU table. Error # 3125 - " is not a valid name...".
Thanks,
Sheldon Potolsky