FollowHyperlink - blind login not working

Posted on 2006-05-04
Last Modified: 2008-03-17
I have an external web application I'd like to lauch from within my Access application.  The 3rd-party provider gave me the URL string for a blind login.


The URL works just fine when I paste into a browser or when attached to a desktop shortcut.

Problem:  When I attempt to launch from MSAccess using FollowHyperlink, I get to the correct page, but the user info is not being passed correcty to complete the blind login correctly.  I get a "session expired" msg at the web app.

Is there another way to launch an external browser to a known URL from within MSAccess??



Question by:markp99
    LVL 3

    Expert Comment

    Try creating a form and use the insert hyper link (ctrl+K) to create the required link. you should be able to pass the user id and password as part of the command.

    The other method you mentioned earlier about the folow hyperlink, have you retried to refresh the session? if theis works then you could add the appropriate code to where you have the followhyperlink statement.


    Author Comment

    Hi Rohit,

    Good idea to use the hyperlink approach instead of a button.  Unfortunately, I get the same issue.  The blind login is not successful.

    I am guessing that the ampersand (&) in the URL string may be a culprit, but I am not sure.
    LVL 3

    Expert Comment

    if that is the case , and I am guessing try this :

    "" ie putting the address in quotes or

    =""&"&"&"password=user002"&"&"&"op=login" which is effectively putting the ampersand in quotes and therefore treated as text and not as a concatentator



    Author Comment

    No luck.

    I have resorted to using an embedded browser within my Access app.  The same URL string works just fine with .Navigate.

    I was initially concerned about the fixed window size of the embedded browse and the need to provide even the most rudimentary web controls, but it looks like this should work.

    Strange issue on the external browser.

    Thanks for you assistance.

    Accepted Solution

    PAQed with points refunded (500)

    Community Support Moderator

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now