MrDavidThorn
asked on
Access XML import problems
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?
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
resolved question myself by importing each object one at a time and then running code.