The DBA had never heard about any limit on the path.
The limit in windows SHOULD be 245 characters.
My hunt on the internet for answers encountered this text:
"I was running MS Access 2000 with Windows 2000 - Service Pack 3.
(Note: It is NOT Office 2000 with SP3, it is the OPERATING SYSTEM with SP3!)
With this configuration the problem is that the path length is limited to 128 characters.
I installed Service Pack 4 for Windows 2000,
restarted my computer and everything is working fine and without any problems!
Hope, that this solution is working for you as well! Good luck! "
I checked my SP and found it to be 2, IIII-haaaa... then it hit me. I'm not running WIN 2000 any longer, I'm running XP. Back to square one.