If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
.BAT file Copy Access DB on an Interval
Hi-
I'm familiar enough with the commands to copy files using a batch file. What I can't find much help on is being able to copy an Access file on a certain interval. let's say, at 5pm every night. Can anyone give me a quick refresher on this? Or refer me to somewhere to look? ..I'm not getting good results from google. i looked into copying the database programatically but, it looks to be more of a hassle than a batch file that runs itself at 5 every night. |
#2
|
|||
|
|||
.BAT file Copy Access DB on an Interval
I have not done the update on a time interval but I have put the .bat in the
startup of the workstation or on the icon to execute the database so that an update always runs before opening the program on the workstation. Hope this helps. "chriscooz" wrote: Hi- I'm familiar enough with the commands to copy files using a batch file. What I can't find much help on is being able to copy an Access file on a certain interval. let's say, at 5pm every night. Can anyone give me a quick refresher on this? Or refer me to somewhere to look? ..I'm not getting good results from google. i looked into copying the database programatically but, it looks to be more of a hassle than a batch file that runs itself at 5 every night. |
#3
|
|||
|
|||
.BAT file Copy Access DB on an Interval
Chris - wouldn't using scheduled tasks be easier? You can schedule your .bat
file to run at a certain time each day. Many years ago I also tried doing what you are trying (when my DOS was not so rusty as now and I was using expanded bat commands) but if I remember correctly I finally found a little backgroud 'timer' to use. No idea any more what it was called, but if using XP, the Schedulded Tasks should work. Yrs - Dika "chriscooz" wrote: Hi- I'm familiar enough with the commands to copy files using a batch file. What I can't find much help on is being able to copy an Access file on a certain interval. let's say, at 5pm every night. Can anyone give me a quick refresher on this? Or refer me to somewhere to look? ..I'm not getting good results from google. i looked into copying the database programatically but, it looks to be more of a hassle than a batch file that runs itself at 5 every night. |
#4
|
|||
|
|||
.BAT file Copy Access DB on an Interval
On Mon, 14 Nov 2005 07:10:08 -0800, chriscooz
wrote: Hi- I'm familiar enough with the commands to copy files using a batch file. What I can't find much help on is being able to copy an Access file on a certain interval. let's say, at 5pm every night. Can anyone give me a quick refresher on this? Or refer me to somewhere to look? ..I'm not getting good results from google. i looked into copying the database programatically but, it looks to be more of a hassle than a batch file that runs itself at 5 every night. Dika's advice about using the Windows Scheduled Tasks is the ticket for what you want. One caution: if the database is open - and especially if anyone is editing any data in it - at the time you make the copy, you are almost certain to get database corruption in the copy. Access is NOT designed to support "hot backups". In your .bat file, check first to see if there is a .ldb file with the same name as the database in its folder; this indicates that someone is using the database and that the copy should not be run until later. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
Importing Contacts from Work to Home Computer in Outlook | Debbie | Contacts | 3 | March 16th, 2005 09:14 PM |
Print field description of a table | Larissa25 | General Discussion | 34 | February 6th, 2005 04:30 AM |
Adding staff photographs to my database | KK | New Users | 2 | September 3rd, 2004 07:41 AM |
Upload Image | Jason MacKenzie | General Discussion | 1 | September 1st, 2004 04:38 AM |