Run MS Access Macro through Excel VBA - Macro has ODBC connection

[skahmed]

Hello,

I would like to be able to run a MS Access macro through Excel. The MS access macro requires an ODBC (for Oracle Connect) user name and password.

How can I

i) run the macro using excel vba script and
ii) make the ODBC connection without being prompted to enter the username and password (i.e. incorporate it into the VBA script)

Thanks