How can I prevent the SQL Login box when accessing SQL Azure from an Access front end?

How can I prevent the SQL Login box when accessing SQL Azure from an Access front end? I've tried putting the credentials in the ODBC connection string for the native client and I've tried connecting from VBA; all unsuccessfully, I always have to login once I poke at the Azure SQL database from a form. Thank you

4 answers

Solved.

Max, Please post the solution so others can get help too! :)

Max or John, Please post solution! Having same problem!

Hi Karol, the solution is to delete the link in Access and ReLink it via External Data - ODBC. Be sure to select Save Password and you should be good to go.