I have created an ADP front end connecting to a SQL 2000 Database. Due to the current Network Infrastructure I am using SQL authentication for the users to logon.
The Front end will be deployed by Group Policy to Approx 60 Users. However the front end opens the authentication logon box with the Default Username already entered. I want both the Username & Password boxes to be blank ready for the Front end user to type in their credentials.
What I am thinking is that I create a basic SQL User(to use as the default for Data Link) with a Saved Password which allows them just to connect to the SQL database.
With the Autoexec Macro I then open a form asking them to put in their individual logon credentials, which when accepted allows them to input, query the database. Failing logon obviously chucks them out of the system.
Am I going the right way about this???
The Front end will be deployed by Group Policy to Approx 60 Users. However the front end opens the authentication logon box with the Default Username already entered. I want both the Username & Password boxes to be blank ready for the Front end user to type in their credentials.
What I am thinking is that I create a basic SQL User(to use as the default for Data Link) with a Saved Password which allows them just to connect to the SQL database.
With the Autoexec Macro I then open a form asking them to put in their individual logon credentials, which when accepted allows them to input, query the database. Failing logon obviously chucks them out of the system.
Am I going the right way about this???
