?
Solved

MS Access 2010 and Azure Logging into SQL Server

Posted on 2012-09-13
4
Medium Priority
?
465 Views
Last Modified: 2014-11-12
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
0
Comment
Question by:alevin16
  • 2
  • 2
4 Comments
 
LVL 85
ID: 38395301
I'm assuming those are just linked tables?

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.
0
 

Author Comment

by:alevin16
ID: 38395341
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!
0
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 38398882
SSMA just moves the tables to the server. You should still remove and recreate the links after running SSMA. When you do that, you'll see the "Save Password" checkbox.
0
 

Author Comment

by:alevin16
ID: 38399463
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).
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question