I currently have a fairly good sized (9 mb) database that I have shared with people. Upon initial installation, they are prompted to enter their local network data (basically where their copy of the database will be residing on their network).
As I make updates to the FE file, I make it available for them to download. So far, this works (for the most part).
I also have an installer file that pushes a copy of the FE file to each users desktop. The idea was for the first desktop install to be ran by them (using the install file saved on their network), with subsequent updates installing automatically upon them opening the database from their desktop.
Here is where I have a majority of the issues. Right now, if they open up their desktop version, it alerts them that they are not running the current version, the installer file then opens automatically while simultaneously closing their desktop version. This leads to some issues as the installer file hangs or the desktop version doesn’t close right away. Then, when the install has completed, it automatically opens the desktop version again which drops a run-time error.
Is there a way to simplify this process while still allowing the update to run? Are there some tried and true auto-update modules or code out there to speed the process up that won’t throw errors?
As I make updates to the FE file, I make it available for them to download. So far, this works (for the most part).
I also have an installer file that pushes a copy of the FE file to each users desktop. The idea was for the first desktop install to be ran by them (using the install file saved on their network), with subsequent updates installing automatically upon them opening the database from their desktop.
Here is where I have a majority of the issues. Right now, if they open up their desktop version, it alerts them that they are not running the current version, the installer file then opens automatically while simultaneously closing their desktop version. This leads to some issues as the installer file hangs or the desktop version doesn’t close right away. Then, when the install has completed, it automatically opens the desktop version again which drops a run-time error.
Is there a way to simplify this process while still allowing the update to run? Are there some tried and true auto-update modules or code out there to speed the process up that won’t throw errors?