My small Access database is linked to mulitple tables in my large Oracle database.
I want to have the Oracle database update the Access Database on a daily basis.
This works great for my needs, but I want to do it "behind the scenes" multiple times daily.
I set up the Access Database to launch multiple times daily using the autoexec feature to set off the job.
The problem I have is that it prompts me for my Oracle Database (DSN)Password each time it connects to Oracle.
Is there a way I can code around this prompt. I have coded a module to run at autoexec that is connecting to my Oracle Database when the job runs, but I still am prompted for the password when the update query runs.