FollowHyperlink - blind login not working

Posted on 2006-05-04
Medium Priority
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.

Example:  http://www.somewhere.com/action/login?username=user002&password=user002&op=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
  • 2
  • 2

Expert Comment

ID: 16605130
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

ID: 16605318
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.

Expert Comment

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

"http://www.somewhere.com/action/login?username=user002&password=user002&op=login" ie putting the address in quotes or

="http://www.somewhere.com/action/login?username=user002"&"&"&"password=user002"&"&"&"op=login" which is effectively putting the ampersand in quotes and therefore treated as text and not as a concatentator



Author Comment

ID: 16607096
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

CetusMOD earned 0 total points
ID: 16831218
PAQed with points refunded (500)

Community Support Moderator

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

807 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