[AccessD] File-name length limitations for linked tables

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


More information about the AccessD mailing list