[AccessD] Question from member regarding passing passwords

Steve Turner's messages aren't making it to the list, so I'm passing along 
this message for him.

Susan H.



The question I have left is can you pass the password for a SQL Express 
database in code so you don't have to type it in. I have an excel spread 
sheet that pulls the active jobs from our database so we can select them in 
a combo box to charge mileage for our vans.

The database was in a Dbase file but we changed it to SQL Express. This is 
now the database for our Custom Time Sheet program and every time you access 
the thing through Access or Excel you have to type in this password. The old 
programmer put the password in, we really don't even need a password for the 
data, and the new programmer fixing some of the problems left by him hasn't 
had time to see if it can be eliminated.