Code to Automate Archiving

's Computer Specifications

We have several apps that were written in Access and every two weeks, we have
to archive our databases based on certain dates. I was wondering if anyone
was aware of a way to automate this process? If so your help would be
greatly appreciated.
Thanks
Nick

's Computer Specifications

See:
Archive: Move records to another table
at:
http://allenbrowne.com.au/ser-37.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"nmarano" <(E-Mail Removed)> wrote in message
news:AE5CF9B5-42DC-416F-B035-(E-Mail Removed)...
> We have several apps that were written in Access and every two weeks, we
> have
> to archive our databases based on certain dates. I was wondering if
> anyone
> was aware of a way to automate this process? If so your help would be
> greatly appreciated.
> Thanks
> Nick

's Computer Specifications

Allen,

Is there a way to set this to run at 5AM every Friday?

Thanks
Nick

"Allen Browne" wrote:

> See:
> Archive: Move records to another table
> at:
> http://allenbrowne.com.au/ser-37.html
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "nmarano" <(E-Mail Removed)> wrote in message
> news:AE5CF9B5-42DC-416F-B035-(E-Mail Removed)...
> > We have several apps that were written in Access and every two weeks, we
> > have
> > to archive our databases based on certain dates. I was wondering if
> > anyone
> > was aware of a way to automate this process? If so your help would be
> > greatly appreciated.
> > Thanks
> > Nick
>
>
>

's Computer Specifications

If the computer is on, and the database is open, you could leave a (hidden)
form open, and use its Timer event to periodically check the value of Now()
and run the routines on cue.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"nmarano" <(E-Mail Removed)> wrote in message
news:FE10B983-67B4-4185-8134-(E-Mail Removed)...
> Allen,
>
> Is there a way to set this to run at 5AM every Friday?
>
> Thanks
> Nick
>
> "Allen Browne" wrote:
>
>> See:
>> Archive: Move records to another table
>> at:
>> http://allenbrowne.com.au/ser-37.html
>>
>>
>> "nmarano" <(E-Mail Removed)> wrote in message
>> news:AE5CF9B5-42DC-416F-B035-(E-Mail Removed)...
>> > We have several apps that were written in Access and every two weeks,
>> > we
>> > have
>> > to archive our databases based on certain dates. I was wondering if
>> > anyone
>> > was aware of a way to automate this process? If so your help would be
>> > greatly appreciated.
>> > Thanks
>> > Nick

's Computer Specifications

Allen,
Thank you very much for your help. One last question. Can this be done
using Access 97?

"Allen Browne" wrote:

> If the computer is on, and the database is open, you could leave a (hidden)
> form open, and use its Timer event to periodically check the value of Now()
> and run the routines on cue.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "nmarano" <(E-Mail Removed)> wrote in message
> news:FE10B983-67B4-4185-8134-(E-Mail Removed)...
> > Allen,
> >
> > Is there a way to set this to run at 5AM every Friday?
> >
> > Thanks
> > Nick
> >
> > "Allen Browne" wrote:
> >
> >> See:
> >> Archive: Move records to another table
> >> at:
> >> http://allenbrowne.com.au/ser-37.html
> >>
> >>
> >> "nmarano" <(E-Mail Removed)> wrote in message
> >> news:AE5CF9B5-42DC-416F-B035-(E-Mail Removed)...
> >> > We have several apps that were written in Access and every two weeks,
> >> > we
> >> > have
> >> > to archive our databases based on certain dates. I was wondering if
> >> > anyone
> >> > was aware of a way to automate this process? If so your help would be
> >> > greatly appreciated.
> >> > Thanks
> >> > Nick
>
>
>

's Computer Specifications

Allen,

Would I be better off setting up a Macro and then using a Windows Scheduler
to call the Macro which would run the module set up to archive?

"Allen Browne" wrote:

> If the computer is on, and the database is open, you could leave a (hidden)
> form open, and use its Timer event to periodically check the value of Now()
> and run the routines on cue.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "nmarano" <(E-Mail Removed)> wrote in message
> news:FE10B983-67B4-4185-8134-(E-Mail Removed)...
> > Allen,
> >
> > Is there a way to set this to run at 5AM every Friday?
> >
> > Thanks
> > Nick
> >
> > "Allen Browne" wrote:
> >
> >> See:
> >> Archive: Move records to another table
> >> at:
> >> http://allenbrowne.com.au/ser-37.html
> >>
> >>
> >> "nmarano" <(E-Mail Removed)> wrote in message
> >> news:AE5CF9B5-42DC-416F-B035-(E-Mail Removed)...
> >> > We have several apps that were written in Access and every two weeks,
> >> > we
> >> > have
> >> > to archive our databases based on certain dates. I was wondering if
> >> > anyone
> >> > was aware of a way to automate this process? If so your help would be
> >> > greatly appreciated.
> >> > Thanks
> >> > Nick
>
>
>

's Computer Specifications

Probably.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"nmarano" <(E-Mail Removed)> wrote in message
news:B6C7E992-D6BE-4A62-ABE4-(E-Mail Removed)...
> Allen,
>
> Would I be better off setting up a Macro and then using a Windows
> Scheduler
> to call the Macro which would run the module set up to archive?
>
> "Allen Browne" wrote:
>
>> If the computer is on, and the database is open, you could leave a
>> (hidden)
>> form open, and use its Timer event to periodically check the value of
>> Now()
>> and run the routines on cue.
>>
>>
>> "nmarano" <(E-Mail Removed)> wrote in message
>> news:FE10B983-67B4-4185-8134-(E-Mail Removed)...
>> > Allen,
>> >
>> > Is there a way to set this to run at 5AM every Friday?
>> >
>> > Thanks
>> > Nick
>> >
>> > "Allen Browne" wrote:
>> >
>> >> See:
>> >> Archive: Move records to another table
>> >> at:
>> >> http://allenbrowne.com.au/ser-37.html
>> >>
>> >>
>> >> "nmarano" <(E-Mail Removed)> wrote in message
>> >> news:AE5CF9B5-42DC-416F-B035-(E-Mail Removed)...
>> >> > We have several apps that were written in Access and every two
>> >> > weeks,
>> >> > we
>> >> > have
>> >> > to archive our databases based on certain dates. I was wondering if
>> >> > anyone
>> >> > was aware of a way to automate this process? If so your help would
>> >> > be
>> >> > greatly appreciated.
>> >> > Thanks
>> >> > Nick

's Computer Specifications

Yes.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"nmarano" <(E-Mail Removed)> wrote in message
news:07F7633C-7595-4797-96B9-(E-Mail Removed)...
> Allen,
> Thank you very much for your help. One last question. Can this be done
> using Access 97?
>
> "Allen Browne" wrote:
>
>> If the computer is on, and the database is open, you could leave a
>> (hidden)
>> form open, and use its Timer event to periodically check the value of
>> Now()
>> and run the routines on cue.
>>
>>
>> "nmarano" <(E-Mail Removed)> wrote in message
>> news:FE10B983-67B4-4185-8134-(E-Mail Removed)...
>> > Allen,
>> >
>> > Is there a way to set this to run at 5AM every Friday?
>> >
>> > Thanks
>> > Nick
>> >
>> > "Allen Browne" wrote:
>> >
>> >> See:
>> >> Archive: Move records to another table
>> >> at:
>> >> http://allenbrowne.com.au/ser-37.html
>> >>
>> >>
>> >> "nmarano" <(E-Mail Removed)> wrote in message
>> >> news:AE5CF9B5-42DC-416F-B035-(E-Mail Removed)...
>> >> > We have several apps that were written in Access and every two
>> >> > weeks,
>> >> > we
>> >> > have
>> >> > to archive our databases based on certain dates. I was wondering if
>> >> > anyone
>> >> > was aware of a way to automate this process? If so your help would
>> >> > be
>> >> > greatly appreciated.
>> >> > Thanks
>> >> > Nick

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automate Code Signing	Dave Mills	Microsoft Excel Discussion	0	1st Oct 2008 07:27 AM
Which code to automate XML import	=?Utf-8?B?UGF1bA==?=	Microsoft Access External Data	0	12th Nov 2006 04:02 PM
Using VBA code to automate a process	j_lugo311@yahoo.com	Microsoft Outlook VBA Programming	7	21st Apr 2006 04:26 PM
Automate archiving and deletion of reports	Raj	Microsoft Windows 2000 Networking	4	14th Feb 2006 11:23 PM
Automate this code	hotherps	Microsoft Excel Programming	4	23rd Jul 2004 12:40 AM