jwcolby
jwcolby at colbyconsulting.com
Tue Feb 8 07:00:54 CST 2011
Borge, I need your help. I will open my system to you, I will teach you about Hamachi and you can teach me about authentication in a run time world. I cannot give you the keys in AccessD though so contact me off line. Anyone else too who knows any part of this and wants to learn any part. We will keep all discussions other than actual user name / passwords on this list. Thanks, John W. Colby www.ColbyConsulting.com On 2/7/2011 8:35 PM, Borge Hansen wrote: > John, > > We use a system / machine ODBC dsn with SQL Server Authentication Login > ID and password > > We drop and relink tables on opening of the runtime using hardcoded Login ID > and password > > Even if user can access properties of linked table, the Login ID and > password will not be shown, see sample below: > > ODBC;DSN=bhnc10_RMS_DATA;Description=RMS_DATA;APP=Microsoft Office > 2003;WSID=GODWIT;DATABASE=RMS_DATA;QueryLog_On=Yes;StatsLog_On=Yes;;TABLE=dbo.tblBookingRequest > I am curious about the hamachi, please provide link for more information and > instrucitons for how to set up > > regards, > borge > > > > On Tue, Feb 8, 2011 at 3:05 AM, jwcolby<jwcolby at colbyconsulting.com> wrote: > >>> 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<http://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 >>> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >>