Drew Wutka
DWUTKA at marlow.com
Wed Aug 20 01:08:47 CDT 2003
Personally haven't run into this, but I wouldn't be surprised if the actual limit was 255 characters, for the entire linked table information (driver, etc....), which would be a normal text field. I wouldn't think it is that big of an issue though. You can always strip a path down to three parts. The machine, the share, and the file. Or if it's local, and you have an exceptionally deep file struction, you could always substitute a drive letter for a long path. Drew -----Original Message----- From: Joshua B [mailto:lists at jbsolutions.com.au] Sent: Tuesday, August 19, 2003 10:21 PM To: Access Developers discussion and problem solving Subject: [AccessD] File-name length limitations for linked tables 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com