Jim Hewson
JHewson at karta.com
Wed Aug 17 08:53:22 CDT 2005
Doris, I appreciate the response. Sorry, I have been remiss in replying sooner. I started to create an ADP and then talked with one of my co-workers. He suggested that using a System DSN in the ODBC Data Source Administrator located under Control Panel -> Administrative Tools would work. Since we have about five users that get some benefit from this database, we used that method. It worked great... No login and Access pulls just what is needed from the SQL server. Thanks for your help. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike & Doris Manning Sent: Saturday, August 13, 2005 2:30 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] SQL Server BE - Access FE If you use an ADP with Windows authentication, you will get around that. Otherwise you'll have to pop-up a login box each time you open the database to set the connection. Doris Manning mikedorism at verizon.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson Sent: Saturday, August 13, 2005 2:14 PM To: AccessD Subject: [AccessD] SQL Server BE - Access FE Works good.... I can't seem to figure out how the security on the SQL Database can be used. When I first go into the FE, the forms work... when I need to look at any of the data, I get an error message about the login failed for the user. I click the OK button and get another screen with Server visible and the Use Trusted Connection checked. When I uncheck the box, the Login ID and Password are available to enter the correct information. I've looked into the help and couldn't find what I needed. I have one user in SQL Server with the correct security (Read-Only). How do I connect without going through that sequence? TIA Jim -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com