Hi all.
I currently have a split database that i am constantly working on and releasing updated versions to my coworkers. The way i currently handle this is by using a version number in sequence. 1.0.1, 1.0.2 etc...
I have tblVersion on the front end of the database which keeps track of the current front end version that is installed on the machine. (It also displays the version in a text box on the main screen)
Right now for example i am working on version 1.0.7 and my coworkers use 1.0.6. My goal is to be that when i move onto say version 1.0.8 and input that value into the table on say the back end (tblLatestVersion), version 1.0.7 would be the next current version ready to be released. I would like access to lookup OnLoad of the main screen what the current version is and if it matches the latest version (tblLatestVersion). If for example they still had version 1.0.6 loaded when access opened up but it detected 1.0.7 was the latest version released, it would prompt the user with a message box "Your version is out of date, please download latest version".
They would click OK and it would then take them (Run a path hyperlink) to the shared folder where i keep the latest version for them to copy and replace the existing one.
How would i go about this?
Thanks
I currently have a split database that i am constantly working on and releasing updated versions to my coworkers. The way i currently handle this is by using a version number in sequence. 1.0.1, 1.0.2 etc...
I have tblVersion on the front end of the database which keeps track of the current front end version that is installed on the machine. (It also displays the version in a text box on the main screen)
Right now for example i am working on version 1.0.7 and my coworkers use 1.0.6. My goal is to be that when i move onto say version 1.0.8 and input that value into the table on say the back end (tblLatestVersion), version 1.0.7 would be the next current version ready to be released. I would like access to lookup OnLoad of the main screen what the current version is and if it matches the latest version (tblLatestVersion). If for example they still had version 1.0.6 loaded when access opened up but it detected 1.0.7 was the latest version released, it would prompt the user with a message box "Your version is out of date, please download latest version".
They would click OK and it would then take them (Run a path hyperlink) to the shared folder where i keep the latest version for them to copy and replace the existing one.
How would i go about this?
Thanks