My dilemma. I've created a separate database (Special Program Database) which has 12 tables linked to another database (District Database).
My specific question is this: How can I refresh the linked tables in the Special Program Database on a daily basis without doing it manually? Can I use a command button programmed to run a macro? Not my first choice. Or, can I program a script/code to run at a specific time during the night to refresh the tables?
I'd rather program a code so that users don't press the command button to try to refresh while others are updating/entering data.
Thanks in advance.