Associate
- Joined
- 2 Sep 2007
- Posts
- 1,997
Hi All
I don't even know how to begin to solve this problem. We have an Access database which uses data from an external website, this data (csv file) is downloaded to a folder on our server. At the moment users click on a button in the Access database, this opens up Internet Explorer with a direct URL to download the file all they do then is save the file into a specified folder and the Access database uses this data.
Here is the problem, the URL is not a direct URL it is a manager's login, but the URL doesn't contain his password so he was happy for me to use this solution. Think of like this, it's like me logging into my bank account and me giving you the URL and being you are able to see my bank account. I know it is very poor security by the external website but it was good for us. Well today this external website have totally changed their system so this cannot be done anymore.
Users need to be able to download this file at any time but obviously the manager doesn't want to give his login details for the external site so they can download the file.
Is there anyway I can create an application in VB.NET or have some automated macro which will open up Internet Explorer, go this website, login and download the file automatically, this way the users will not see the manager's password.
Phew, I hope I've explained it enough well.
Help greatly appreciated!
I don't even know how to begin to solve this problem. We have an Access database which uses data from an external website, this data (csv file) is downloaded to a folder on our server. At the moment users click on a button in the Access database, this opens up Internet Explorer with a direct URL to download the file all they do then is save the file into a specified folder and the Access database uses this data.
Here is the problem, the URL is not a direct URL it is a manager's login, but the URL doesn't contain his password so he was happy for me to use this solution. Think of like this, it's like me logging into my bank account and me giving you the URL and being you are able to see my bank account. I know it is very poor security by the external website but it was good for us. Well today this external website have totally changed their system so this cannot be done anymore.
Users need to be able to download this file at any time but obviously the manager doesn't want to give his login details for the external site so they can download the file.
Is there anyway I can create an application in VB.NET or have some automated macro which will open up Internet Explorer, go this website, login and download the file automatically, this way the users will not see the manager's password.
Phew, I hope I've explained it enough well.
Help greatly appreciated!
Last edited: