MS Access 2010 and Azure Logging into SQL Server

Posted on 2012-09-13
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

Question by:alevin16
    LVL 84
    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.

    Author Comment

    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!
    LVL 84

    Accepted Solution

    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.

    Author Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now