Solved

Access XML import problems

Posted on 2010-11-23
3
470 Views
Last Modified: 2012-08-13
Have a strange problem in Access, I have some VBA code that imports an XML document (application.ImportXml) - this has been work well with no problems, then I upgrade my database by adding /amending objects none of which have any impact on the import XML code. After upgrading the XML Import stops working and now crash's access - the error message is one of a cant read memory one and doesnt really mean much, has any one come across this problem before and could it be system table related?
0
Comment
Question by:MrDavidThorn
  • 2
3 Comments
 
LVL 9

Expert Comment

by:Stephan_Schrandt
ID: 34194818
I've seen this many times before. Often it occurs if you have some class modules  in your database. Sometimes it helps to edit one of it, add an additional empty line somewhere (just press enter) and save it. If this doesn't help, you have to open a new database and import all of the objects. I don't know if this is system table related, never had time to search for the reason of that.
0
 

Accepted Solution

by:
MrDavidThorn earned 0 total points
ID: 34195445
Have resolved the problem, I imported a query that linked to tables that had additional fields created but the  fields in the upgraded db still reflected the old objects, although I would have expected access to report that the joins didn't exist instead it fell over on the export function even though the function did not use the query in question, a little odd but there you go. Thanks for your help Stephan.
0
 

Author Closing Comment

by:MrDavidThorn
ID: 34224515
resolved question myself by importing each object one at a time and then running code.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now