How do I refresh data imported from a service without closing and reopening my access file
This is the setup I have:
One MS-SQL 7 database exporting data to my access file through a service every 2 minutes. But if my access file is opened and data is exported to it, then I need to close and reopen my access file in order to view the newly exported data.
Thus, my question is how can I refresh my access file with the newly exported data without having to close and reopen it?