MS Access and Security Credentials
Using a REST request to import data into MS Access 2007, and the web service requires HTTP authentication, the format is
http://USERNAME:PASSWORD@HOST/WEBSERVICE
http://USERNAME:PASSWORD@HOST/WEBSERVICE