I've searched through the forums and online and haven't really found a workable solution to what I'm trying to do.
I have a split database where the backend is hosted off-site on a SQL server. There is a local server onsite running an SQL-lite type program that we used to test the database during development. What I'd like to do is set up a process where we can switch to the local server when we lose internet connectivity so that we can continue to collect data without the need to revert to paper forms.
Is there a way to programmatically set up a button/macro/form to make the switch? In my head I envision being able to click on a button and have the links move from the hosted server BE to the local server BE without any intervention from the user. The switch would only be a change in where the server is located, the table names and number would be identical. I've seen code for when it's an Access BE and FE, but nothing for SQL server side BE's.
The BE is hosted off-site because of our IT policy, so keeping it local isn't an option. However, we can use a temporary, local server for network downtime and then append the tables to the hosted server.
Is this something that's do-able or am I asking for too much flexibility?
Thanks,
DD