I've got an Access app with a form containing a Web Browser object. In VBA, I I use the object to navigate to a particular B2B website, programmatically enter login credentials and execute the login 'Click' event. Afterward, I scrape the web page for data.
This has worked fine for months. However, suddenly, the app freezes after submitting the login credentials. CPU runs high, but the app is frozen. I don't even get the 'Not responding' message in the title bar, nor in Task Manager.
I've tried almost everything to troubleshoot, with no results. I confirmed it's not the actual code causing the problem, as I created a new db from scratch, added a form with the WB control and navigate to the website, pre-login. Manually, in the WB control, I enter the login credentials and get the same result.
Navigating to and logging into other websites is not a problem. Just the one website.
I've now tried this on various workstations and various versions of Access, without any luck. Any suggestions would be greatly appreciated.
Thanks in advance.
This has worked fine for months. However, suddenly, the app freezes after submitting the login credentials. CPU runs high, but the app is frozen. I don't even get the 'Not responding' message in the title bar, nor in Task Manager.
I've tried almost everything to troubleshoot, with no results. I confirmed it's not the actual code causing the problem, as I created a new db from scratch, added a form with the WB control and navigate to the website, pre-login. Manually, in the WB control, I enter the login credentials and get the same result.
Navigating to and logging into other websites is not a problem. Just the one website.
I've now tried this on various workstations and various versions of Access, without any luck. Any suggestions would be greatly appreciated.
Thanks in advance.