I am using Access and VBA to create an XML Document that will post to an IP for the purpose of faxing documents. I have the VB code written to accomplish this but my question is relating to...
Will the XML Document be limited to the 64k (I think) max size of a string variable??? This becomes a "VERY LARGE" string variable because the PDF file that's actually being faxed is encoded and included within the <document_list> </document_list> tags. I did not post all the encoded results within those tags but I think you can get the idea if you review the output below from the strXMLDocument variable after it is created. Within my test environment I can create and send faxes with 17 pages and have not received any errors but when the client ran the application in their environment the first time the got the message...
Run-time error '3163' The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
The next time they ran the application it worked, sent the faxes and did not generate any errors. Strange!!!!
This is the only variable in the whole scheme of things I could think of that could possibly cause that error and is why I'm asking the question.
Dim XmlDocument as string
XmlDocument = "xml document is created here" and the output looks like the following ...
<?xml version="1.0" encoding="UTF-8"?>
" <--------------This very large and is the encoded pdf file
Mybe there's a better way to create that xml document rather than store it to a string variable.