help! run a query with ADO or DAO


Im desperately trying to run a query with code. I have tried using the Docmd
command which worked but the database Im connecting to has linked tables and
its asking for a password and i dont know how to specify one.

I have tried using ADO ...not many resources on internet I can connect to
the database with connection string but when i say set rs =
cnn.execute("qryMyquery") I get an error.

can anyone help me or point me in the right direction? maybe i could use