|
|
|
date: Thu, 13 Apr 2006 15:29:01 -0700,
group: microsoft.public.access.replication
back
Re: Nightly Synchronization
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 wrote in
> news:7DA82F18-9208-4239-879B-28A5C294B9B7@microsoft.com:
>
> > 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/
>
date: Thu, 13 Apr 2006 17:52:02 -0700
author: Kenny
Re: Nightly Synchronization
"Kenny" 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. The guy that will be using the laptop is not very computer literate. He just knows how to open the database and use it.
>
> "David W. Fenton" wrote:
>
> > Kenny wrote in
> > news:7DA82F18-9208-4239-879B-28A5C294B9B7@microsoft.com:
> >
> > > 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/
> >
date: Thu, 13 Apr 2006 18:02:01 -0700
author: Kenny
Re: Nightly Synchronization
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
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 wrote in
>> news:7DA82F18-9208-4239-879B-28A5C294B9B7@microsoft.com:
>>
>> > 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@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
date: Fri, 14 Apr 2006 15:32:56 GMT
author: jacksonmacd
Re: Nightly Synchronization
Thanks for the help David and jacksonmacd. I think I can handle it from
here. :)
"jacksonmacd" wrote:
> 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
> 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 wrote in
> >> news:7DA82F18-9208-4239-879B-28A5C294B9B7@microsoft.com:
> >>
> >> > 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@telusTELUS.net
> remove uppercase letters for true email
> http://www.geocities.com/jacksonmacd/ for info on MS Access security
>
date: Fri, 14 Apr 2006 09:12:02 -0700
author: Kenny
|
|
