troubleshooting Question

How do I refresh linked tables automatically on a time basis or with a command button programed to do so?

Avatar of rhlopez1
rhlopez1 asked on
Microsoft Access
12 Comments3 Solutions426 ViewsLast Modified:
Good Morning,
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.

rlopez
 
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 3 Answers and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros