I have an Access Macro (not vba, just standard macro) that runs a series of Make Table Queries each night. An ODBC connection is used to link to the tables. Occasionally when I run the queries, a box pops up asking for my username and password for the ODBC connection. This hangs up my macro. Is there a way through the macro to enter that information? Keep in mind that it doesn't always ask at the same spot. I think it depends on the last time I accessed the particular table. Thanks for any suggestions.
Chris