Re: Nightly Synchronization

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You can just as easily schedule an MDB file to open as you can with a
VB program. Just have your application automatically open the form
upon startup. Then after the synchronization is completed, quit from
Access. No need to use VB at all.


On Thu, 13 Apr 2006 17:52:02 -0700, Kenny
<Kenny@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I have seen the code to synch when the application starts or shutdown, but
would it work if the laptop was not running Access when connected back to the
network?

I was thinking about using this code and save it as VB program, and then
scheduling the VB program to run every night to synch the laptop and the
server.

"David W. Fenton" wrote:

Kenny <Kenny@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:7DA82F18-9208-4239-879B-28A5C294B9B7@xxxxxxxxxxxxx:

I am wanting to synchronize a laptop every night to the server.
We are running Access 2000 and do not have the Developers edition,
so Microsoft Replication Manager is not an option. The laptop is
unplugged from the network during the day, and plugged back in at
the end of the day. We can replicate it manually, but prefer to
automate the task.

The code for this using DAO is very, very simple. It's been posted
in this newsgroup repeatedly by many people. Indeed, it's basically
one line of code that does the synch. It should be easy to create a
subroutine that could be called when the application starts up on
the laptop and when it shuts down that, if connected to the LAN,
synchs. It would also be good to provide a UI so the user could
synch at will.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

**********************jackmacMACdonald@xxxxxxxxxxxxxx
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
.

Relevant Pages

  • Re: Is solid edge comparable, better or worse than SW?
    ... SE synch and recommended a dell 2,000 dollar laptop... ... 2 mhz and 2 gig of ram.. ...
    (comp.cad.solidworks)
  • Mac Mail Synch Desktop to Laptop
    ... I would like to synch my desktop Mail pop mail messages to my laptop. ... these workarounds do not work for me. ...
    (comp.sys.mac.apps)
  • Re: Synchronize Error
    ... I have Windows 2000 on my laptop and use the synchronization feature a lot. ... My files are located on the office network so that my secretary can get at ... there's no network to synch with anyway for that set up. ...
    (microsoft.public.windowsxp.basics)
  • Re: Synchronize data Vista <> XP?
    ... to the laptop and copy same to the portable hard drive, ... I have not seen the need to use Briefcase since I stopped using Zip ... Disks around 2001, and I cannot see how it would be ideal in this situation. ... 'automatically in synch'. ...
    (microsoft.public.windows.vista.general)
  • Re: Desperate : Functions that will not work?????
    ... Tips for Access users - http://allenbrowne.com/tips.html ... "Benn Vosloo" wrote in message ... > Then I have a laptop with Win 2K also running Access 2000. ...
    (microsoft.public.access.reports)