troubleshooting Question

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

Avatar of Eric Sherman
Eric ShermanFlag for United States of America asked on
Microsoft Access
7 Comments1 Solution4995 ViewsLast Modified:
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.

ET
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros