One way to do this is have a small table with the current version number in it and have the main form of the database have a hidden field with the version of the FE. The start-up code that runs with the form uses SQL to compare the value on the form with the value in the table. If they do not match then a pop-up message tells the user to update. Optionally, you can use a form with a link to where the updated FE is located on a form. I used this method on several databases in the past and I'm sure I can dig up some examples if this seems interesting.
--- In MS_Access_Professionals@yahoogroups.com, "jfakes.rm" <jfakes@...> wrote:
>
> I have seen several versions of a Frontend (FE) updater, however, I would like to figure out the best way to complete the following steps:
>
> 1. How I can save a file on a shared server that a user would click on once to copy the FE updater database as well as the FE to the users computer.
>
> 2. I would like the icon for the FE updater to be put on the users desktop so that is the only icon they will see for the database. This would be what the user clicks on to check the version of the FE and either update it to the correct version then open the FE, or if the user has the current version, open the FE.
>
> I am not an IT person, just someone that has been "blessed" (stuck) with updating numerous databases with no training.
>
> I assume there is a way to do this using VBA, however, I don't have any VBA training either so I would like to see if there is a simple way to do this.
>
> Thanks,
>
> John F.
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (10) |
Tidak ada komentar:
Posting Komentar