Access interface with WebControl object

Question

We have an Access database that has forms embedded with the WebControl ActiveX object. Each WebControl loads a local html file that includes some basic javascript functions written in-house, as well as references to Google Maps API. Our Access forms exchange information with the embedded web page via ExecScript and html document properties in VBA.

Up until last week, this process worked just fine. As of this week, all of the in-house javascript functions no longer work when called from Access using VBA. But I can load the html documents in an external browser and the functions appear to run. Anyone know if the WebControl object has changed significantly with any recent updates? We haven't had any trouble until this week, and none of the code (both VBA and javascript) has changed.

Answer 1

Here's the error I'm getting:

'retrieveDbsEntries' is a function in a js file on the local server. I get the same message when trying to run other functions from the same form.

Answer 2

Thanks for the response.

Javascript is enabled, and I can run internal functions from a ScriptControl object, just not the WebBrowser control.

I tried changing the registry settings, but no luck.

There were security updates installed last week, so that may be the problem. Not sure if our network admin will allow them to be removed but I'll give it a try.

Answer 3

So you get an error?  What is it?

Perhaps you need to set the emulsion mode of the browser ActiveX, see http://www.devhut.net/2013/10/18/webbrowser-activex-control-google-maps-invalid-character-scripting-error/

Answer 4

You could check if anything was installed on that date: Control panel > Programs and Features > Installed Updates, and uninstall it.

One possibility might be that JavaScript is disabled. Maybe you can think of a way to test that? Perhaps a test page with a simple alert() in it?

Another possibility might be compatibility level was changed. There is a registry setting for that. See https://blogs.msdn.microsoft.com/patricka/2015/01/12/controlling-webbrowser-control-compatibility/ or several other pages.