Solved

problem creating XML file in Access 2013

Posted on 2014-11-27
4
139 Views
Last Modified: 2014-12-01
this is what I get<infoTable xmlns="">
The requirement is that there be no name space tags on any elements.
code.txt
test2.inftab.xml
0
Comment
Question by:durick
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 63

Expert Comment

by:Fernando Soto
ID: 40469293
Hi durick;

If you do not want any namespace in the document then try removing these lines from your code.

'eleInformationTable.setAttribute "xsi:schemaLocation", "http://www.sec.gov/edgar/document/thirteenf/informationtable eis_13FDocument.xsd"
eleInformationTable.setAttribute "xmlns", "http://www.sec.gov/edgar/document/thirteenf/informationtable"
'eleInformationTable.setAttribute "xmlns:n1", "http://www.sec.gov/edgar/document/thirteenf/informationtable"
eleInformationTable.setAttribute "xmlns:xsi", "http://www.w3.org/2001/XMLSchema-instance"

Open in new window

0
 

Author Comment

by:durick
ID: 40469871
0
 

Author Comment

by:durick
ID: 40469872
does not explain the - <infoTable xmlns=""> entries
0
 
LVL 63

Accepted Solution

by:
Fernando Soto earned 500 total points
ID: 40471592
The question states, "The requirement is that there be no name space tags on any elements.", but yet the root node does have a namespace associated with it.

From your last post, "does not explain the - <infoTable xmlns=""> entries", this statement from your code,

eleInfoTable = docDocument.CreateElement("infoTable")

which uses a single string as a parameter does not insert a namespace into the node. I would look at your code again and make sure you are not using the one with two string parameters of which the second one would be the namespace.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question