Jack MacDonald <ja**************@telus.net> wrote in
news:23********************************@4ax.com:
You could use Access' Replication, and use a timer on a hidden
form to synchronize the data on a specified schedule (e.g. every 5
minutes or so...)
Or you could use the synchronizer that comes with the developer
tools and MichKa's TSI Synchronizer (which provides an interface to
a lot of functionality that is otherwise not exposed) and schedule
the synchs that way, so they'd happen independent of a perticular
front end being opened.
The Replication Manager scheduling interface allows a minimum
sheduled synch interval of 15 minutes.
But I'm having a really hard time conceiving of an application where
Jet would be an appropriate data store that would need higher
granularity than that.
Indeed, I think the whole scheme of mirroring is probably a mistake
-- if you really need that kind of reliability, Jet is the wrong
tool. And if you're trying to work around corruption issues, then
you should solve those problems instead of multiplying your problems
by introducing more code and more tasks that could fail.
One caveat for scheduled synchs in a replicated database: make sure
that all your memo fields are unbound, because if a scheduled synch
occurs while a memo is being edited, you can corrupt the source MDB.
--
David W. Fenton
http://www.bway.net/~dfenton
dfenton at bway dot net
http://www.bway.net/~dfassoc