Recently just started using SQL Server 2000, so please bare with me. I am using Access as the front end and have a form with drop down boxe that uses the values from a table SQL. However, everytime I click on it asks me for my SQL password.
We are not using Windows authentication as of yet because we are currently upgrading to Active Directory. So, right now we have to use SQL server password, unless you are in the Domain where the SQL server resides in, which most users are not. Is it possible to create a VBA code within Access to automatically have SQL recognize my SQL password so that it does not prompt me everytime?