I want to have a FRESH LOCAL copy of the external DB table(s), every time I open te Access DB.
When I choose for a "connected" table, it is not a "local" copy and performance is terrible.
But when I choose to import the table, it is a "local" copy but then I have to do this manually every time.
The goal is to have a macro or VBA that can do this automatically on open. Any suggestions?
When I choose for a "connected" table, it is not a "local" copy and performance is terrible.
But when I choose to import the table, it is a "local" copy but then I have to do this manually every time.
The goal is to have a macro or VBA that can do this automatically on open. Any suggestions?