Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...
MS Access Forum / Modules / DAO / VBA / February 2005

Tip: Looking for answers? Try searching our database.

Code to Automate Archiving

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
nmarano - 23 Feb 2005 20:09 GMT
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
Reply to this Message
Allen Browne - 24 Feb 2005 03:48 GMT
See:
   Archive: Move records to another table
at:
   http://allenbrowne.com.au/ser-37.html

Signature

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.

> We have several apps that were written in Access and every two weeks, we
> have
[quoted text clipped - 4 lines]
> Thanks
> Nick
Reply to this Message
nmarano - 24 Feb 2005 13:33 GMT
Allen,

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

Thanks
Nick

> See:
>     Archive: Move records to another table
[quoted text clipped - 9 lines]
> > Thanks
> > Nick
Reply to this Message
Allen Browne - 24 Feb 2005 17:23 GMT
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.

Signature

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.

> Allen,
>
[quoted text clipped - 17 lines]
>> > Thanks
>> > Nick
Reply to this Message
nmarano - 24 Feb 2005 17:35 GMT
Allen,
Thank you very much for your help. One last question.  Can this be done
using Access 97?

> 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()
[quoted text clipped - 21 lines]
> >> > Thanks
> >> > Nick
Reply to this Message
Allen Browne - 25 Feb 2005 01:33 GMT
Yes.

Signature

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.

> Allen,
> Thank you very much for your help. One last question.  Can this be done
[quoted text clipped - 29 lines]
>> >> > Thanks
>> >> > Nick
Reply to this Message
nmarano - 24 Feb 2005 21:02 GMT
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?

> 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()
[quoted text clipped - 21 lines]
> >> > Thanks
> >> > Nick
Reply to this Message
Allen Browne - 25 Feb 2005 01:33 GMT
Probably.

Signature

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.

> Allen,
>
[quoted text clipped - 31 lines]
>> >> > Thanks
>> >> > Nick
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.