Login required, can I automate this?

[kmacd6951]

I have scheduled an Access macro to run, using Windows Scheduled Tasks.

The problem I am having is that when the Scheduled Task opens Access (or if I open Access manually), I am required to enter an ODBC login and password. Is there a way to add this to my marco so it fills it in for me?

 

[Cbrine]

When you select your table from the ODBC link Setup screen there is a checkbox for remember password(or something like that). Just click on it when you link the table. The password should no longer be requested.

You will need to delete the table now, and link it again with this option set.

 

[kmacd6951]

Thank you for your assistance! That was what I needed.