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!