How to bypass captcha using access vba RRS feed

  • Question

  • My application is using access vba for data extraction from webpages.At present i am facing issue regarding captcha check.I use below mentioned methods for dealing with this check but unable to find permanent solution. I use sleep method and use 3 second time interval between each request.Also i use timer and stop code execution after every 8 minutes and restart execution after 10 minues.But still captcha check is creating problem for me.
    Wednesday, February 8, 2017 4:19 PM

All replies

  • I think you are asking for the impossible. The whole point of Captcha is so you can't programatically read the text. It takes human eyes to read it.

    Bill Mosca

    Wednesday, February 8, 2017 4:44 PM
  • Is there any methd or any logic that will i use in my code so that captcha message not displayed against my webrequest?
    Wednesday, February 8, 2017 5:07 PM
  • Because when i use above method i.e after 8 minutes i stop code and after 10 minutes restart with 3 minutes sleep time then captcha is visible after one hour i.e when data extraction is more then then captcha is visible so is there any method that captcha will be bypased for more hours.
    Wednesday, February 8, 2017 5:18 PM
  • I highly doubt it.  The duration is set by the server unless you can identify in the HTML javascript ... and dynamically edit it.

    Theses counter measures are put in place to stop automated bots and the likes.  You could always ask the website owner if they could give you unfettered access.

    Daniel Pineault, 2010-2016 Microsoft MVP Professional Support: http://www.cardaconsultants.com MS Access Tips and Code Samples: http://www.devhut.net

    Wednesday, February 8, 2017 6:26 PM
  • The answer is that you shouldn't be trying to bypass captcha. It was put their for a reason by the creator of the web site and for whatever reason, which is valid to them, they don't want people running bots and screen scraping tools against their web site.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    Wednesday, February 8, 2017 10:26 PM
  • Hi tahirsatti123,

    The purpose of captcha is to prevent machine generated web requests and only allows valid human generated web requests.

    bypassing the captcha means you want to violate the rule.

    I do not suggest you to bypass captcha.

    try to contact the website developers , if your request is valid and they can try to provide some way to fetch the data from their website.

    nobody will suggest you anything on this topic, as if you developed something like this then it can harm that website.

    if we misunderstand something in your case then let us know about that and try to clear all the things.



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, February 9, 2017 2:43 AM