Hi,
this may be a very stupid question, but here it comes.
I'm using a large application (split database) on a server (I don't have admin-rights, it's from my work). In frontend, all tables are correct linked to multiple backend-(data)-files.
So far so good.
But sometimes, one of the backend-files gets "locked" on the server (read-only) and mostly, the next day (I think after a nightly reset of the server), everything works fine again. Automatically.
This means that some days, the data can't get updated until the night.
So I'm thinking of using a second backend ("mirror") in case the original backend is locked. I can copy the original backend to a new file with a new name, but it's impossible to change (in front-end) every link to the tables (linked table manager).
It would be good if I could use a simple table in my frontend with the name of the back-end-file that has to be used. Thus avoiding "manual" update of all linked tables with the manager.
So I could change the name of the back-end-file to the mirror-file in case of and all of my colleagues would then work with the data in the mirror-file.
Or use a "switch" (with vba) to switch between 2 backend-files: the original one and the mirror-copy
Is this possible or is there another solution?
Thanks for helping.
Wim