Darren - Active Billing
darren at activebilling.com.au
Mon Jan 31 18:31:04 CST 2011
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 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Tuesday, 1 February 2011 2:15 AM To: Access Developers discussion and problem solving Subject: [AccessD] SQL constant harassment I am doing a demo Access database against a SQL Server BE. Access is constantly "harassing" me with pop-ups to provide log in information. At odd times, not always. But when it happens it is for each (bound) form getting data. So a main form with subforms, and apparently even combo boxes, it will pop up the box to select the user authorized to do this. What do I do to make this go away? -- John W. Colby www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com