Enter ODBC password on opening of report?

[Laura Cook]

I am not an expert in the Access field; I hope someone will have an
understanding of what I am asking. If needed, please ask if more
information.



I have created a database that links two tables to ODBC linked tables (I am
not even sure what ODBC stands for). It also contains a query based off
these tables and a report based on the query. The purpose for this database
is for end-users only. The end-users have a low knowledge of Access. I
have the database set up so that when it opens, a message box pops up asking
for certain criteria (from the query), they enter the ODBC password, and
then the report pops up. Their options are very limited here (no database
window, status bar, or menus).



The powers that be have now been informed me that they do not want the
end-users to have to enter the password or even know what the password is.
Is there a way I can have the password entered for them? Through a macro or
module?



Thanks for any help or advice you can give.