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 ...
10th October 2013, 11:45 AM #1
- Rep Power
Copy Access Database to computers Script
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?
10th October 2013, 11:59 AM #2
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).
14th October 2013, 10:55 AM #3
- Rep Power
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.
Last Post: 25th April 2013, 05:10 PM
Last Post: 3rd October 2008, 12:36 PM
Last Post: 15th February 2008, 12:06 AM
By dezt in forum How do you do....it?
Last Post: 5th July 2006, 12:43 PM
By tosca925 in forum Scripts
Last Post: 21st November 2005, 10:49 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)