I have a program that I created in MSAccess 2010. I will be using Sagekey to create an installation package and give it to our users across the US. It is not the most advanced program in the world but it has a great deal of VBA code.
Here is my problem. The front end is in Access while the backend tables are moved to Azure. When my users install the program (after it has been run thru Sagekey) on their computer and try to run it, they get a box asking them to log on to the SQL Server (the Azure server).
I would like to use a trusted connection or find a way to get rid of this box entirely because my users would not be able to handle copying the Azure server name into the Login ID box (plus they all would have to use the admin ID and password).
How can I get rid of this box? Any help is appreciated!
I have attached a copy of the SQL box I get with my ID and the server ID blacked out