I have made an Access VBA application that runs on my local PC. The appl. is connected to an external MS SQL-database on a server. The connection use an IP-adr, a username and a password and it works fine. But before I can conntact the SQL-server I have to do a Authentication on the web with username and password,looks like this:http://aut.agdernett.no:2000/
. I think it is a fireWall or something. I have got the the username/password and it works fine when I run this on the browswer manualy before I run my application.
My questiion is: How can I give this authentication in my application instead of manualy on the web. Is it possible to do this by instructons(VBA) ?