Kitty's Great Calendar Project gets its data from an Excel table the user generates outside of Access (ExcelCaledar).
Right now, I have the table ExcelCalendar linked to the CalendarProject database but it appears that Access doesn't automatically refresh the data when the CalendarProject database link opens.
I thought that links were supposed to reflect changes in the underlying data. In fact, I understood that to be the major advantage of using a link instead of just importing the data to a table.
My users have good hearts but tiny brains so I can't expect them to use the Link Manager to refresh the data before proceeding.
How can I use VBA code to refresh the link automatically? (200 points)
And for the other 100 points, IS there an advantage to using the link rather than just importing the data each time I need it?