I have a request where a jet report needs to be presented on a display and gets refreshed every 5 minutes. So the file will always be open on that display, and the data needs to be refreshed every 5 minutes automatically without anyone doing anything.
Is this possible? I've read that you can use Excel VBA to get Jet to refresh a report but I'm not sure how that would work with the file always being open. I haven't had a chance to test the VBA route yet, wondering if anyone has done something similar