I'm in Access and I run any basic SQL query such as:
select COUNT(*) from employee_data where title = 'Programmer'
and the next thing you know is a window pops up where I need to click on the "Machine Data Source" tab and then the appropriate "Data Source Name" which then has me type in my password. This allows me to tell it which database I am trying to tap into. (Lotus Notes in this instance) Is there any way to incorporate this info into the query so I don't have to keep retyping this info in?