Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008

    Unanswered: Problem with Application distribution

    Please can someone help or guide me to resolve this problem. I have an access DB called "Monthyly.accdb". Monthly.accdb resides in the directory "\\Camp\public\Provider Network Relations\". I do not want to be going to the user work place desktop to install the application any time there is a change or modification to "Monthly.accdb". I want a script or a method when I send the user an email with "Monthly.accdb anttached, once the recepient clicks on the attached document, the application will run, create a directory on "C drive - "c:\Monthly.accdb and install "monthly.accdb on the user desktop. I will appreciate any help that can be accorded.


  2. #2
    Join Date
    Mar 2009
    Provided Answers: 14
    If all pcs are in the same domain and if you have enough provileges on the domain or on the clients machines you can run a script from your machine:
    NET USE Z: \\Client_1\C$
    MD "Z:\Office Program Files"
    MD "Z:\Office Program Files\Sales"
    XCOPY \\Alpha\Sales\Billing.mdb "Z:\Office Program Files\Sales\Billing.mdb" /I/Y
    NET USE Z: /D
    Have a nice day!

  3. #3
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 8
    try and do Sinndho idea

    not your email idea

    I did the same thing sent a batch file out and TRYED to get the user to double click and they wouldn't and I still get bleam for not updating the user computer

    My Mark 1 verson
    when a user log into there computer it would copy the new files to the local computer.

    Mark 2 version
    wrote a menu program which started up when they login and
    when the user went to run a program it would check to see if there was a newer version on the server and copy it to the local drive.
    hope this help

    See clear as mud

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

  4. #4
    Join Date
    Oct 2009
    google around and you should find Stephan Lebans code by the name of : AutoFE Updater (or something like that....) at least I think it was Lebans...

    Is kind of a common issue when the FE goes thru changes how to efficientlly install them. In a way the entire blade computer industry developed for more or less the same reason.

    Somewhat of a tradeoff of time vs code; if your LAN allows you to see one folder on everyone's PC you can simply manually copy the FE to each person and overwrite the file....

    the links to the BE don't change so you shouldn't have to do any linking...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts