+ Post New Thread
Results 1 to 3 of 3
Windows Thread, Copy Access Database to computers Script in Technical; Hi We have a database that we use in school. I need a method to copy a database from a ...
  1. #1

    Join Date
    Feb 2008
    Posts
    324
    Thank Post
    51
    Thanked 3 Times in 3 Posts
    Rep Power
    14

    Copy Access Database to computers Script

    Hi

    We have a database that we use in school. I need a method to copy a database from a central location and custom icon to the laptops and certain desktops that updates and copies a new one over every time. What is the best method to achieve this?

    Thanks

  2. #2


    Join Date
    May 2009
    Posts
    2,908
    Thank Post
    259
    Thanked 770 Times in 585 Posts
    Rep Power
    270
    Put the DB on a network location and link the icon to a batch file which first makes a local copy of the DB before firing up the program. Assumes your DB is a reasonable size (i.e. the copy doesn't take an hour).

    (ETA - might not be the 'best' way but should work).

  3. #3

    Join Date
    Mar 2012
    Location
    Manchester
    Posts
    12
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Or if you have server 2008 or newer, set up a group policy object to do it for you. No scripting needed. It's also a lot cleaner rather than nasty outdated batch files.

    The GPP you are looking for is in Computer Configuration\Preferences\Files. Create a new update rule and point the source file to your access DB and the destination to the location you want it to go on your machine.

    Bear in mind you will need client side extensions installing on your station if it's running XP. Link found here.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 7
    Last Post: 25th April 2013, 04:10 PM
  2. Replies: 1
    Last Post: 3rd October 2008, 11:36 AM
  3. Universal access to computers
    By zag in forum Hardware
    Replies: 10
    Last Post: 14th February 2008, 11:06 PM
  4. Copy 2 files to every computer on the network
    By dezt in forum How do you do....it?
    Replies: 7
    Last Post: 5th July 2006, 11:43 AM
  5. Replies: 12
    Last Post: 21st November 2005, 09:49 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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