MS Access 2010 and Azure Logging into SQL Server
Hello Everyone,
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
Thanks!
Screen-shot-2012-09-13-at-8.50.4.png
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
Thanks!
Screen-shot-2012-09-13-at-8.50.4.png
ASKER
Yes they are all just linked tables. I am using SSMA to move all the tables to Azure. I do not remember seeing something like you mentioned when I did it but I could have just missed it. I am going to try it again and hopefully that is all it is. I really appreciate the help!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Actually I saw in SSMA a checkbox for saving the passwords overall for the project. I tried that and it seemed to work. I really appreciate the help! You pointed me in the right direction (and I did not know about SSMA just moving them, I am going to experiment with what you mentioned so I can get more fluent in this).
If so, then you should delete and recreate the links to the Azure server, and be sure to check the Save password textbox when doing this. This should store the links w/ password, and your users should not have to re-enter after that.