Maximum Size of String Variable to Hold XML Document Created with VBA???

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"?>
<single_fax_info xmlns="http://www.protus.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <SchemaVersion>1.2</SchemaVersion>
  <login_key>
    <user_id>54321</user_id>
    <user_password>mypassword</user_password>
  </login_key>
  <single_fax_options>
    <billing_code>Monthly Statement</billing_code>
    <from_name>MyCompany</from_name>
    <tiff_image_flag>false</tiff_image_flag>
    <resolution>high</resolution>
  </single_fax_options>
  <fax_recipient>
    <fax_recipient_number>13367891234</fax_recipient_number>
    <fax_recipient_name>John Doe</fax_recipient_name>
  </fax_recipient>
  <document_list>
<document document_content_type="application/PDF" document_encoding_type="base64" document_extension="PDF">JVBERi0xLjMNCjEgMCBvYmoNCjw8DQovQ3JlYXRvciA8RkVGRjAwNzAwMDY0MDA2NjAwNUYw
MDZFMDA2RjAwNkMwMDY1MDA3NDAwNzQwMDY1MDA3Mj4NCi9Qcm9kdWNlciA8RkVGRjAwN
"
"  
"                          <--------------This very large and is the encoded pdf file
"
"
"
JSVFT0YN
Cg==</document>
  </document_list>
</single_fax_info>


Mybe there's a better way to create that xml document rather than store it to a string variable.

ETStart Free Trial