I am currently working on a database which has links to two other databases both of which are password protected. The problem occurs when the main database needs to access data in the others as it prompts for their passwords to be entered.
I was wondering if anyone knew a way to automate this so that the user would not be asked for the password but instead it would be coded into the main database.
Any help would be appreciated.
I was wondering if anyone knew a way to automate this so that the user would not be asked for the password but instead it would be coded into the main database.
Any help would be appreciated.