Nagesh
Member
- Local time
- Today, 12:29
- Joined
- May 10, 2020
- Messages
- 31
Hi
Whenever there is modification required to Access database, I change the Linked Table to local BE to carry out the work.
I complete the modifications / testing using Local BE and then link all tables to the Server BE.
I save the FE file as ACCDE/ACCDR and then distribute the same to users.
My Query;
Is there a way in which I can 'save' the contents / linked tables of 'data source' (eg server BE / Local BE copy)?
Currently, during modifications, I am first 'deleting' the links to server BE and then going through the whole process of selecting individual tables to link tables to the local BE.
It would be great if I could just save the Server BE path and corresponding tables and also Local BE path and corresponding tables.
That way I can switch between Server and Local BE whenever required.
Whenever there is modification required to Access database, I change the Linked Table to local BE to carry out the work.
I complete the modifications / testing using Local BE and then link all tables to the Server BE.
I save the FE file as ACCDE/ACCDR and then distribute the same to users.
My Query;
Is there a way in which I can 'save' the contents / linked tables of 'data source' (eg server BE / Local BE copy)?
Currently, during modifications, I am first 'deleting' the links to server BE and then going through the whole process of selecting individual tables to link tables to the local BE.
It would be great if I could just save the Server BE path and corresponding tables and also Local BE path and corresponding tables.
That way I can switch between Server and Local BE whenever required.