Automatic Updater with Access

[Arun]

1)Can we use Automatic Updater for VBA Access file?

2)At Present iam able to download updates from my server.

The way the update appears to work is that when an update is found it initiates the download and update. I want to change this tool to download it silently and an update notification(window) should appears when the update is fully downloaded. Could you please tell how can i change it?

3)Is there a way for wyBuild to restart the app when update is finsished if it is not an executable file(.accdr)?

[Wyatt]

1)Can we use Automatic Updater for VBA Access file?

No. The AutomaticUpdater is only for .NET apps. You can use wyUpdate as a standalone updater (which lets you do everything that the AutomaticUpdater can do, except you have to use commandline arguments instead of an API access).

2)At Present iam able to download updates from my server.

The way the update appears to work is that when an update is found it initiates the download and update. I want to change this tool to download it silently and an update notification(window) should appears when the update is fully downloaded. Could you please tell how can i change it?

You can't with wyUpdate as a standalone updater (you can, however, with the AutomaticUpdater). Or you can use wyUpdate in a Windows Service and have the Windows Service notify your VBA app that the download is complete.

3)Is there a way for wyBuild to restart the app when update is finsished if it is not an executable file(.accdr)?

Yes. Use a batch file to launch the accdr file however you open it (I presume by passing the file as an argument to Access) and execute that batch from wyUpdate after the update completes successfully.

[Arun]

Thanks for your responce. In my 3rd question the answer you said about batch file.So I tried running my application.exe using batch file when updates completed.Here it is working when i give exact path like C:\Programfiles\application.exe. But my requirement here is i need to give the path of program's folder where the user install it. So is there any options to run this application.exe using bacth file?

[Wyatt]

Pass the application name as commandline parameter when executing the batch file. See the "%basedir% variable" section of the executing files article.

[Arun]

I placed my bat file(to run application.exe) in Temporary folder but my all installation files are in Program's folder.Here i have used Command line switches: %basedir%\application.exe. even i could not run my application.exe after updating is complete?

[Wyatt]

Firstly, the commandline is not magic. You have to make use of the commandline arguments you pass to the batch file. So passing this:

Code: Select all

"%basedir%app.exe"

Will expand in the batch file in the %1 variable as something like this:

Code: Select all

"C:\Program Files\Your App\app.exe"

Notice how "%basedir%" has a trailing slash. That is, notice how I used this:

Code: Select all

"%basedir%app.exe"

And not this:

Code: Select all

"%basedir%\app.exe"

[Arun]

Wyatt iam sorry to disturb you again. Here if i pass exact path to batch file then its working fine even i placed it in temperory folder but here i need run app.exe from base directory because of end users have xp machines.. but if i pass "%basedir%app.exe" code to batch file then it could not run app.exe.

I placed bat file in Temporary folder in Files&Folders of wyBuild. My app.exe is in Programfiles.I need to run this app.exe after updates. So please help make it work. Thank you.

[Wyatt]

Try echoing out the %1 commandline argument in the batch file. That way you can see what is being passed in and if you did everything correctly.


Since you're executing an exe file, why don't you just execute it directly? Why are you bothering with a batch file?

[Arun]

Here iam using .accdr file for executing. So i took batch file run App.accdr file.

[Arun]

Hi Wyatt, Here i want to run my .accdr file after Update is complete Using VBA code. So can you please suggest me How can i use code after complete wyBuild update? In VBA access when can i use condition to run .accdr file.(How can we write code for this)?
i want like this :
If Update is complete then open file(start exe).