Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 26th, 2003, 12:42 PM
LH LH is offline
Registered User
 
Join Date: Sep 2003
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Auto update of client... ideas?

Hello. I have an Access .ade client that communicates with SQL Server on our network. It is a hassle when we make structural changes to the client application because I need to go to each users machine and install the updated client. What would be great is when a new version of the client is available (some specified place on the network?), it would somehow automatically replace the old version of the client with the new one on the users machine without much input from the user. Does anyone know an easy way to do this?

Thanks for any help,

LH

 
Old September 26th, 2003, 01:01 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Hi LH,

Front end updater scripts and utilities abound on google and news list archives. A lot of people just place a short cut on the client that runs a batch file. Here's a couple of approahes I've tucked away:

From Andrew Haslett:

We just use this simple batch script:

***********************************************
*@echo off
*if not exist "c:\Documents and Settings\All Users\Data\MyDB_V1.mde" goto
getdb:
goto startdb
:getdb
*md "c:\Documents and Settings\All Users\Data" >nul
*del "c:\Documents and Settings\All Users\Data\MyDB_V*.mde" >nul
*copy l:\master\MyDB_V1.mde "c:\Documents and Settings\All Users\Data" >nul
*:startdb
*"c:\program files\microsoft office\office\msaccess.exe" "c:\Documents and
Settings\All Users\Data\MyDB_V1.mde"
**********************************************

The database in this example is called MYDB_V1.mde. When I create a new version, following conventions, it will be called v1.1 or v2 etc, so we simply change the name in the script.

The shortcut on all users desktops points to this shortcut.

From Bill Mosca:

Is this on a network? If so and assuming that the FE is installed in the same place on everyone's PC, have your network people send out a shortcut to write the new file over the old one.

I had a project once where the FE changed constantly, basically because the finance department was always asking for new features. The FE contained a local version table plus a version table which was linked to the latest version on a server.

On opening, the FE ran a function that checked to see if the version numbers matched. If they did not, an update message was displayed and a small utility mde was opened. The FE then shut down. The utility copied the new file over the old one and then re-opened the FE before closing itself. The only requirement is that the FE be installed in the same place on everyone's PC or you have to add code to look for the file.

~~~~~~~~~~~~~

You might also check out Tony Towe's FE Updater Utility to automate the process at:

http://www.granite.ab.ca/access/autofe.htm

HTH,

Bob


 
Old September 26th, 2003, 02:10 PM
LH LH is offline
Registered User
 
Join Date: Sep 2003
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the suggestions. This helps alot






Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Update of script file.... rupen Javascript How-To 2 November 17th, 2006 11:03 AM
Auto update timestamp field TwoNames PHP Databases 2 September 26th, 2004 06:01 PM
Auto OK on UPDATE Dialog Cr0vaX Access VBA 3 June 24th, 2004 01:24 AM
auto-update multiple records in subform stoneman Access 1 February 8th, 2004 12:19 AM
auto update table field nkrukovsky Access VBA 2 November 4th, 2003 05:28 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.