Re: "An unexpected error has occurred" - A97

Sorry: I don't know anything about how Access 97 could be hiding XML code in
VBA. If anyone else does, please contribute.

The stuff that is happening outside of Access (such as how IE or OE work)
would be due to other security settings that have been changed with the
update, but the disappearing VBA code makes no sense to me.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MLH" <CRCI@xxxxxxxxxxxxxx> wrote in message
news:rm1532l824q65fn59hvahrio5huo30pllm@xxxxxxxxxx
Allen - I think I have a clue. Can you tell me
how to determine exactly when I installed the
SP2 update? I just did it in the past 2-3 weeks.
It took HOURS to run!

I am just now discovering that ALL my work in
all my databases having any modules with XML
calls has been HIDDEN. I cannot SEE the code.
I know its there, though. That's what's causing
the error I'm getting. I went back to apps I'd written
last June - none of the XML procedures appear
completely. The comments display. The error trapping
displays. The generic DIM stmts 'n such display. But
the real meat of the code is hidden somehow. Its
still there and trying to run - but I cannot see nor
modify it. How could MicroSoft bypass all my security
and modify my code w/o permission like that?

SP2 changed my PC somehow - I cannot launch
links in emails now by clicking on them. I have to
copy them and paste them DIRECTLY into IE for
them to work. I lost the ability to open a 2nd instance
of IE by holding down the SHIFT key and clicking
on a link in active IE window.

Even stranger, apps I've rolled out onto customer
sites with A97 runtime since installing SP2 are WORKING. The XML
calls are functioning. But I cannot see nor modify my code
here - and it is not working for me.


.

Relevant Pages

  • Re: Is ADO dead?
    ... Microsoft is really eliminating Access and VBA. ... definitions and reporting in XML. ... Server Express without VBA definitely seems to be where MS is ... No VBA behind a report. ...
    (comp.databases.ms-access)
  • Re: Forms writing to txt-files
    ... I don’t know enough of this (XML), therefore I cant really say whether ... VBA to interact with the document content. ... I am currently working with getting familiar with Field Codes - again. ... Can Word treat a txt-file as it were a regular ...
    (microsoft.public.word.vba.general)
  • Re: "An unexpected error has occurred" - A97
    ... SP2 update? ... all my databases having any modules with XML ... and modify my code w/o permission like that? ... sites with A97 runtime since installing SP2 are WORKING. ...
    (comp.databases.ms-access)
  • Re: How to get data from txt file into table of word template thro
    ... However,for this time, I Just assume that I need to populate the info into ... derived directly from the XML? ... not all customer info need to be in the word document. ... There's no way to answer the question about whether VBA is the best ...
    (microsoft.public.word.vba.general)
  • Re: (No) Future of VBA in Office for Mac?
    ... I for one have never ever used VBA or Macros in Word, and will look forward to the day when Mac Office is based entirely on XML that can be opened by anything that can use XML. ... scripting support will be discontinued in the next version of Office ...
    (microsoft.public.mac.office.word)