Solved

Access XML import problems

Posted on 2010-11-23
3
471 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
type of query 11 40
vba sql wild card passing in code 3 20
Using Multiple  Filters (XLS and XLSX) in File selection dialog 6 26
SQL Group on First occurrence 9 23
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

813 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

10 Experts available now in Live!

Get 1:1 Help Now