如何自动更新MS-Access 2007应用程序 [英] How to automatically update MS-Access 2007 application
问题描述
我有一个与MySql服务器通信的前端Access 2007应用程序.
I have a front-end Access 2007 apllication which talks to MySql server.
我想拥有一种功能，用户计算机上的应用程序可以检测到网络上存在新版本(这并不困难)，并将最新版本下载到本地驱动器并启动它.
I want to have a feature where the application on the user's computer can detect that there is a new version on the network (which is not difficult) and download the latest version to the local drive and launch it.
任何人都没有知识或经验如何做到这一点?
Does anybody has any knowledge or exprience how this can be done?
谢谢
推荐答案
您是否真的需要来查找是否有较新的版本?
Do you actually need to find out if there is a newer version?
我们也有类似的设置，我们只是每次有人复制前端和所有相关文件，然后启动应用程序.
We have a similar setup as well, and we just copy the frontend and all related files every time someone starts the application.
我们的用户不会启动Access或前端本身.他们实际上启动了一个看起来像这样的批处理文件:
Our users don't start Access or the frontend itself. They actually start a batch file which looks something like this:
@echo off
xcopy x:\soft\frontend.mde c:\app\ /Y
c:\app\frontend.mde
当我们开始编写应用程序时，我们也考虑过自动更新，因此决定每次都复制所有内容就足够了.
When we started writing our app, we thought about auto-updating as well and decided that just copying everything everytime is enough.
我们有足够的带宽，因此复制不会造成任何性能问题(大约200个用户).
We have enough bandwidth, so the copying doesn't create any performance problems (with about 200 users).
此外，当我可以确定每次启动应用程序时，无论如何前端都会被覆盖，这对于我作为开发人员来说使事情变得更容易.
我不必担心前端关闭时会自动压缩(并且用户抱怨关闭应用程序花费的时间太长...)，而且崩溃后我也不必处理损坏的前端.
Plus, it makes some things easier for me as a developer when I can be sure that each time the application is started, the frontend is overwritten anyway.
I don't have to care about auto-compacting the frontend when it's closed (and users complaining that closing the app takes too long...), and I don't have to deal with corrupted frontends after crashes.
@Lumis-关于自定义图标:
好的，也许我应该更清楚地说明这一点.只有一个批处理文件，它与前端在同一网络文件夹中.
用户仅在其桌面上具有链接，这些链接都指向网络文件夹中的同一批处理文件.
这意味着:
@Lumis - concerning the custom icon:
Ok, maybe I should have made this more clear. There is only one batch file, and it's in the same network folder as the frontend.
The users just have links on their desktops which all point to the same batch file in the network folder.
This means that:
- 对批处理文件的更改很容易，因为它只有一个 文件放在一个中央位置
- 我们可以更改图标，因为 用户看到的是正常的Windows链接
- future changes to the batch file are easy, because it's only one single file in one central place
- we can change the icon, because what the user sees is a normal Windows link
(顺便说一句，我们没有不更改图标.我们的应用程序仅供内部使用，而我在一家制造公司工作，这意味着几乎没有其他人用户绝对是非技术人员，不必关心图标，只要它在所有计算机上都一样，并且知道它的外观，便可以在桌面上快速找到它...)
(By the way, we did not change the icon. Our app is for internal use only, and I'm working in a manufacturing company, which means that all but very few users are absolutely non-technical and couldn't care less about the icon, as long as it's the same on all machines and they know how it looks like so they can find it quickly on their desktop...)
这篇关于如何自动更新MS-Access 2007应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
