Joshua B
lists at jbsolutions.com.au
Fri Aug 22 00:32:59 CDT 2003
Hi again, Just found a KB article in relation to this, it can be found at http://support.microsoft.com/?kbid=811120. Apparently the limit is 128 characters, and there is no fix other than changing the directory structure. ======= At 2003-08-20, 13:20:00 you wrote: ======= >Hi Group: > >I've just spent most of the day debugging a problem with opening linked tables on the FE. Access simply would not open these tables, and started throwing up all sorts of cryptic errors. After a day of decompiling, compacting, repairing, re-installing, applying patches, searching the web, I decided to move the db to a different directory, and voila! It turns out that there is a limit to the number of characters allowed in a linked table path (it seems to be around 100, I'm not sure of the exact number). Aside from venting my anger, I was just wondering if anyone had come across this problem before, and if there are any fixes for it, other than placing the db in a directory with a shorter path. > > >Best regards. >Joshua B >lists at jbsolutions.com.au >www.jbsolutions.com.au >2003-08-20 = = = = = = = = = = = = = = = = = = = = Best regards. Joshua B lists at jbsolutions.com.au www.jbsolutions.com.au 2003-08-22