Hi,
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
DAO??
