Solved

Access XML import problems

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

860 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