Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Location
    Amsterdam, the Netherlands
    Posts
    6

    Question Unanswered: Automated copy of .ADP to client

    Recently I finished my Access Project (Access 2000, MSDE) and now that I let a few users use the database I run into a practical problem. All of the .ADP-files that I copy to each client, need to be replaced each time there is a change in the original .ADP-file.
    Is it possible to make a shortcut on the clients to a script that first verifies if there is a new version of the .ADP-file. If there is one, the script should copy the newer version to the client and execute it. If not, it should run the present version on the client.

    Hopefully anyone can help me with this!

    Richard

  2. #2
    Join Date
    Jul 2002
    Location
    Australia
    Posts
    147
    This is for MDE files, but shouldn't matter. It's a .cmd script which all users' shortcuts point to. As far as they know, they are simply opening the database.

    (I've prefixed each line with a * in case of wrapping)

    ************************************************** *******
    * @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"
    ************************************************** *******

    Cheers,
    Andrew
    There have been many posts made throughout the world.
    This was one of them.

  3. #3
    Join Date
    Sep 2002
    Location
    Amsterdam, the Netherlands
    Posts
    6
    Andrew: thanks! Just what I was looking for!

    Originally posted by Bunce
    This is for MDE files, but shouldn't matter. It's a .cmd script which all users' shortcuts point to. As far as they know, they are simply opening the database.

    (I've prefixed each line with a * in case of wrapping)

    ************************************************** *******
    * @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"
    ************************************************** *******

    Cheers,
    Andrew

  4. #4
    Join Date
    Jul 2002
    Location
    Australia
    Posts
    147
    Your welcome.
    There have been many posts made throughout the world.
    This was one of them.

Posting Permissions

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