[AccessD] SQL constant harassment

 > I sent a demo SQL dB to you off-list. Did you get it?

AFAICT I did not get that offline.

I am trying to build an access application which installs on a user's system somewhere out in the 
world.

1) They are not local to my machine, they come in to my SQL Server instance over Hamachi.
1a) They have no means to login directly to the server instance with a username / password.
2) They are going to run on a 2007 run-time.
3) The runtime is intentionally unhelpful.
4) In testing it just gives me a "there was an error executing the command" when I try to open a 
form.  When I try to open the same thing under the full version Access it is asking for a logon as 
it attempts to open the first form.

My guess is that the runtime is attempting to open this SQl Server login form and isn't allowed to 
by the runtime.  Thus I have to set up the linked tables to just use a correct username / password. 
  I think I can embed this directly into the sql connect string that is part of the tabledef.connect 
but was attempting to avoid that.  That will be my next test just to ensure that it is in fact the 
issue here.

John W. Colby
www.ColbyConsulting.com

On 1/31/2011 7:31 PM, Darren - Active Billing wrote:
> Hi JC
>
> I sent a demo SQL dB to you off-list. Did you get it?
> It shows how to use Pass through queries
> It has a sample to store your username and password and pass it in your SQL
> connection requests
> There is also the option to set the "Trusted Connection" to yes in the SQL
> connections strings
>
> Many thanks
>
> Darren