Access web site from Access database form

[SteveB]

I am trying to develop code that will enable a user to log into a
secure website from MS Access. I would like to develop a form that
prompts the user for a user name and password and then will pass user
name and password strings to the HTTPS login. I can open the website
using the Shell command, but, I have no idea of how to pass these two
strings to the login form. Has anyone encountered this?

If the above is not possible, can anyone tell me how to pass control
to Internet Explorer; allow the user to excute the tasks on the web
site and then pass control back to Access when the user closes
Internet Explorer?

I have a recently also found a sample.cs written in C# to do this
something like what I am trying to do, but nothing written in VBA.

 

[Patrice]

What is the overall goal ? Using a webservice would be easier.

If this is the user who is responsible for navigating as he wish on the site
I would just let him do what he wish (just launching his browser for him).
Handling the password is the user responsability (ie. if he wish he will ask
the browsdr to remember his password etc...).

In thee worst case, you could use a webbrowser control if you really need to
have your users navigating in a very tight control environment. Not sure to
get the big picture....

--
Patrice


"SteveB" <[email protected]> a écrit dans le message de groupe de
discussion :
(e-mail address removed)...

 

[Patrice]

Or the user should browse to a site but he is not supposed to know the
password ??

 

[SteveB]

Or the user should browse to a site but he is not supposed to know the
password ??

--
Patrice

"Patrice" <http://scribe-en.blogspot.com/> a écrit dans le message de groupe
de discussion : (e-mail address removed)...






- Show quoted text -

The goal to this project is to allow the user to log into a national
website and then let automation take over to download, or import a
database andor spreadsheet to a local server. The web site would then
close automatically, returning the user to the database to perform
other actions. This downloaded file would then be ingested
automatically by the original Access database so that other users (or
case workers in this scenario) can make business decisions concerning
each record in the file. The end goal is keep the user who does the
download and import, from having to open several windows and browse a
website to import these files. The management wants these repetative
downloads streamlined to where the user only needs to enter their user
name and password, click a button, and the VBA behind the button would
pass the security information to the binary web service, download the
file to the local server and import this file into the Access case
management system. The user that does the download function is also a
supervisor of the case workers and controls the work flow to the case
workers. Depending on the volume of records within the downloaded
files, the user (supervisor) may perform this download action every
hour at a minimum and more frequently if volume is high.

So with all of this being said, I am trying to meet the requirements
of the mangement to streamline this particular function. The part I
am having difficulty with is passing the user name and password to the
binary web service to complete the actions required. I hope this
clears up what I am trying to do.

 

[Patrice]

The goal to this project is to allow the user to log into a national

website and then let automation take over to download, or import a
database andor spreadsheet to a local server. The web site would then
close automatically, returning the user to the database to perform
other actions.

Ok so rather than opening the web site using the Shell command and letting
the user to log on the site UI and then only take control, my approach would
be :
- to ask the site credential using an Access UI
- then have Access connect to the site to download/upload the file using the
user provided credentials
- you have nothing to close once done as the user never had to open
anything.

If using DOTNET you can use :
http://msdn.microsoft.com/en-us/library/system.net.webclient.uploadfile.aspx
(or HttpWebRequest if you need more low level control)
http://aspnet.4guysfromrolla.com/articles/102605-1.aspx (shows how to
authenticate using the Credentials property).

If you use an older version of Access a class such Microsoft.XMLHttp

 

[Patrice]

The goal to this project is to allow the user to log into a national

website and then let automation take over to download, or import a
database andor spreadsheet to a local server. The web site would then
close automatically, returning the user to the database to perform
other actions.

Ok so rather than opening the web site using the Shell command and letting
the user to log on the site UI and then only take control, my approach would
be :
- to ask the site credential using an Access UI
- then have Access connect to the site to download/upload the file using the
user provided credentials
- you have nothing to close once done as the user never had to opened
anything.

If using DOTNET you can use :
http://msdn.microsoft.com/en-us/library/system.net.webclient.uploadfile.aspx
(or HttpWebRequest if you need more low level control)
http://aspnet.4guysfromrolla.com/articles/102605-1.aspx (shows how to
authenticate using the Credentials property).

If you use an older version of Access a class such MSXML2.XMLHttp should do
the job (and another group as this one if for discussing VB.NET).