Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access XML import problems

Posted on 2010-11-23
3
Medium Priority
?
484 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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

772 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