code to update local clients from master set?

[Kumba1]

Was wondering how feasible it is to program the localized "modular" versions of access that are on clients throughout my company to check the master database that contains the latest stable versions of my forms/reports/code/etc and update the local versions of those forms/etc with the copy located on the master database... any idears?

 

[KenReay]

Hi

see

http://www.granite.ab.ca/

Tony Toews has an Access routine to do this, have not tried it, so cannot comment further

I normally achive similar result with a batch file script.

Basically what I do is

put master copy of front end on network share

on network share have a version file (eg an empty textfile called version.xxx where xxx is the version number)


on the local C: drive have the users copy of the application, and a version file called version.xxx where xxx is the version number)

on the network share have a batch file which does the following:

looks on the C: drive for a given version of the version file

if found, load Access with the Front end from the C: drive

if not found copy the master front end to the c: drive, copy the master version file to the c: drive, load access with the Front end from the C: drive


On the users desktop, I have a short cut which executes the batch file.

So when I make a new version of my application I put the new version in the network share, add a new version file, edit the batch file script to update the version.

Any user who subsequently laodes the application for the first time since teh upgrade will have a new version copied to their hard drive

I can send you a copy of the batch file it is only about 6 lines long, but at the moment I am not at my office, and do not have copy to hand Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[JeremyNYC]

Kumba,

I use a system very similar to the one Ken described. Int he Developers' section of my website I've got an article called Deploying Databases that goes into the whole thing, and includes the batch file I use.

Jeremy =============
Jeremy Wallace
AlphaBet City Dataworks

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.