Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-13-2012, 06:37 AM   #1
alevin16
Newly Registered User
 
Join Date: Jan 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
alevin16 is on a distinguished road
MS Access - Azure SQL ODBC Connection

I have a front end MS Access database connected to SQL Azure backend. I have used Sagekey to create an installation package out of the program so that I can give it to our users and I don't have to worry about them knowing how to use Access.

When I install the Sagekey-ed program a SQL Server Login window comes up in order to make the connection. I don't want to have my users having to put in the long server name and admin ID/password.

Is there a way in VBA to fill the box or to make the connection trusted? I am an intermediate level programmer so you can see I am banging my head over this.

Any help is appreciated!

alevin16 is offline   Reply With Quote
Old 09-14-2012, 10:00 AM   #2
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,316
Thanks: 15
Thanked 1,601 Times in 1,520 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: MS Access - Azure SQL ODBC Connection

On your own PC, create a File DSN and use that to link the tables. Be sure to check the save password box so the password gets saved. Distribute the DSN with the SageKey package. I don't know offhand where they are stored or how to register them (if necessary) but this is a no-code solution so you might want to see if you can make it work.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 09-14-2012, 10:08 AM   #3
alevin16
Newly Registered User
 
Join Date: Jan 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
alevin16 is on a distinguished road
Re: MS Access - Azure SQL ODBC Connection

Thank you! I am going to give that a shot. I really appreciate the help.

alevin16 is offline   Reply With Quote
Old 10-09-2014, 08:40 AM   #4
GBalcom
Much to learn!
 
Join Date: Jun 2012
Location: Georgia
Posts: 430
Thanks: 20
Thanked 4 Times in 4 Posts
GBalcom is on a distinguished road
Re: MS Access - Azure SQL ODBC Connection

Quote:
Originally Posted by alevin16 View Post
Thank you! I am going to give that a shot. I really appreciate the help.

Alevin16,
How did you make out with this? I'm going to run into the same issue...

Thanks!
GBalcom is offline   Reply With Quote
Old 10-09-2014, 09:01 AM   #5
alevin16
Newly Registered User
 
Join Date: Jan 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
alevin16 is on a distinguished road
Re: MS Access - Azure SQL ODBC Connection

Hey there

Actually I never solved it. I handed it off to the people at Sagekey and they worked their magic. I would highly recommend working with them. They are terrific. If you do call tell Barry that Andy sent you (he'll probably charge you double )

Andy

alevin16 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ODBC connection Access and Oracle willem mosterdijk Modules & VBA 4 04-02-2012 03:18 AM
Question Does Access need to be installed for ODBC connection? PencilEd General 3 07-29-2010 07:36 AM
Connection between Access and ODBC server online marc22 General 3 06-07-2010 07:39 AM
access connection thru odbc to sql server ofersd SQL Server 4 04-12-2010 10:48 AM
Question How to create odbc connection thru ms access code to connect access to sql tables marianne General 3 03-27-2009 05:25 PM




All times are GMT -8. The time now is 12:18 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World