Opening a second DB without the user knowing
I have student records on DBStudents. In a second Database (DBTrainer) the trainer adds his exercises and from a list picks student names from DBStudents. It works; however, when the Trainer opens DBTrainer he has to log into the DBStudent with name and password. I don't want the Trainer to know that he is using the DBStudent at all. (When we set up both DBs with the same name and PW it works, but if one PW is changed it does not work again)
Am I missing the big picture? Or can somebody point me in the right direction....