How do I force JET to write an update to disk?
Here's what I want:
I have a program which sends out mail for all my apps which need to
send mail. The program is invoked with a shell command when needed.
Before it is called, my apps write a record in an MS Access database
containing all the e-mail data - from, to, subject, etc. The e-mail
program is then called with the key of the e-mail record.
The problem is that, since I have moved my apps to a faster (233 MHz)
cpu, the update is not complete when the shelled program reads the
DBEngine.Idle dbRefreshCache does NOT do the trick!