Really? Any update at all? I wish, however, we could identify those situations where a "select into" (that was the only command I had problems with) usually works but rarely doesn't. If there happens to be any update command in the program before the "select into" then apparently the command will go to disk rather than cache. But since 99.99% of my select into's have had no problems, I can't imagine it was because all of them had an update right before... Strange.
Karen > We did some testing and updating ANY table clears the cache, even an > update to a temporary table! > > > > Dennis McGrath > > > >
