MS ACCESS 2010 output path name too long in DOCMD.TRANSFERDATABASE
Posted on 2014-10-15
I have an MS access 2010 database.
It does passthru queries and then exports a result table to another database.
I have problems when the file name of the output database is greater than about 83 characters.
I'm guessing this is because the string built to do the transfer must be less than 255 bytes.
When the max length is exceeded, no data is transferred and no error is given.
how can I calculate the max length of the output Path and File so that it doesn't break