I have a current database application that is used by our sales team. The information used by the database is pulled from our SQL Server. The problem I am running into is most of our sales staff lack the access to the data source when in the field, but still requires the use of the program. I have thought of creating a standalone version of the program for all users to have on their laptops with a standalone table that is a copy of the information in the SQL server. Is their a way to detect if the data source is available and update the standalone table to reflect the new information? Basically I want my database app to check if the data source on the SQL server is available and update accordantly.
Thanks in advance
Thanks in advance