I have an application that I built in Access 97. There are several users who will be accessing the data via an Active Server Page application as well so recently we built an SQL 2000 server to house the data from this application (and others of course). The Access front end will connect to the SQL Server via and ODBC DSN connection.
The problem arises when users open the database. They are prompted for a login and password to access the SQL server. My app has a security that I coded intoit and I don’t want the users to login twice.
How can I create a User account on the SQL server database so that users are not asked to login to the SQL Server when they launch the front-end. In otherwords I need a transparent login to the SQLServer.
We are running a Novell network so I can’t just pass their network login information to the SQL Server. I tried creating a ‘guest’ user account but that still gets prompted for a login.
