schcedualing actions

[Nikos Yannacopoulos]

Roy,

You could set up a separate .mdb (with links to the source and target db
tables) with an autoexec macro or code to do what you want (I would guess
append and delete queries, from what you say, then close), and then use
Windows' Scheduler to run it every Sunday.
You could also use an .exe to do the same, if you have Visual Basic or
something (I use a VB 6.0 .exe to back-up and compact the BE of a fairly big
multi-user database every night, and it's working like a charm!)

HTH,
Nikos

 

[Roy Goldhammer]

Hello there

I have process of sending data to archive. This action should be taken on
sunday (not when the access is open or close) and not when user is working
on the computer.
is there a way to do this on access?

I heared that there is Microsoft Agent who do this
without using sql server

Is somthing like this exists?

 

[Wayne]

We use Total Visual Agent from FMS for this. Works
great. It has a great interface, easy to use and very
powerful. I believe you can download a demo over at
fmsinc.com. We have had it up and running for over a year
without a hitch.

Wayne