Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 4th, 2003, 03:31 PM
ppenn
Guest
 
Posts: n/a
Default Schedule a sychronisation

I have set up a data synchronisation to 7 other sites that runs from a form. I want to to able to set the synchro to run during the evening to avoid network problems. Is there an easy way to do this?
Any suggestions will be gratefully received
Peter
 
Old November 12th, 2003, 09:45 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Here's one method you could do:
If you can set up a macro that will do it, then you're halfway there. (even if it is just a macro that calls some VBA)
Then, all you need to do is create a "Scheduled Task" in Windows, and have it open the file with the macro as a parameter.
Just create a new Scheduled Task that opens Access so that you can get through the wizard, then open the properties, and change it to something like:
Code:
"C:\Program Files\Microsoft Office\Office10\MSACCESS.exe" C:\YourFile.mdb /x YourMacro
The /x switch makes the file run that macro on startup - like an autoexec macro.
Just make sure that you put a Quit command at the end of it so it finishes at the end.

Steven

I am a loud man with a very large hat. This means I am in charge





Similar Threads
Thread Thread Starter Forum Replies Last Post
schedule C-Sharp process Derf ASP.NET 2.0 Professional 9 April 18th, 2008 10:21 PM
About schedule Task brijit VB.NET 2002/2003 Basics 1 November 8th, 2006 01:21 PM
Activity schedule edubbelaar Access 3 November 24th, 2004 11:21 AM
schedule in calender rita General .NET 0 June 19th, 2004 03:37 PM
Time sychronisation between win2000 and win95 Vladimirs VB How-To 0 August 7th, 2003 01:32 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.