Determine name of application being executed...
Is there an easy way to check which program version the user has started? For example if I want to make sure that the user is using the latest front end, I would like to check if “name of program executed” = “ProgramFrontEnd V1”? Thank you so much for any help! Regards Michael
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There are different ways to handle this, such as:
What I do for the table approach is
This way for each version I have a 1-many relationship allowing me to detail the changes between each version. This is great when reviewing things at a later date,
What I don't recommend is storing the version in the filename as this means you need to continuously keep updating shortcut or your launch script.
- You could set a database property and retrieve it.
- You could have a table and read it. (This is what I do)
What I do for the table approach is
tbl_Db_Versions
tbl_Db_Versions_Changes
tbl_Db_Versions_Changes
This way for each version I have a 1-many relationship allowing me to detail the changes between each version. This is great when reviewing things at a later date,
What I don't recommend is storing the version in the filename as this means you need to continuously keep updating shortcut or your launch script.
I use a table (tbl_VersionHistory) which includes a notes field for each time I make changes to the application. It has an ID column, VerNum (text), VerDate, and Comments. When I get ready to deploy the application, I edit the AppTitle and create an AppVersion database property as well, so that my AppLauncher can compare the AppVersion value in the version being run with the current version which is stored somewhere on the file server.
I do the same thing that Dale does; additionally, my Main Menu form writes a record into the WorkLogTb that includes the revision date of the db being opened. That way I can see what version(s) my users are opening, and nag them to update their installation if necessary. :)
I do the same as Paul and display the version on my Main menu. This make it easy for any user to report back to the developer details of problems and you can quickly validate that they are using the right version.
I use to do like Dale and check the version with my deployment utility, but have since switched to always copying a fresh copy of the front-end to my users when they launch the db.
I use to do like Dale and check the version with my deployment utility, but have since switched to always copying a fresh copy of the front-end to my users when they launch the db.
ASKER
Thank you so much for the valuable input! The solution of Gustav sounds the easiest one to use... Again , thank you so much for your help! Cheers Michael
I do the same as Paul and display the version on my Main menu. This make it easy for any user to report back to the developer details of problems and you can quickly validate that they are using the right version.
Ditto here. I go one step further though in that if a user double clicks on the version number display on the main menu, I bring up the version history.
In my table, I have developer notes and user notes (what gets displayed) , along with the # and date deployed.
Jim.
1. use a custom database property that you create (i.e. MyAppVersion, MyAppTitle, etc) and retrieve that.
2. Get the actual file name: CurrentDB().Name
3. Use an internal table to hold the info.
Jim.