>>>
>>>I meant to write recordsource=''. I tried it a few years ago, it caused all kinds of problems. My method have never failed.
>>
>>Both methods have pros and cons. Zap could lead to destructive and irreversible results while = "" would only effect display. I only mean it's not an uppercased "NOT" to use thing.
>>Cetin
>
>I have used the zap solution for years, and I have never had any trouble with it so far. I use it with both for small tables, and for large tables, all are DBFs. The largest I use regularly has more than 5 million records and a size of 950MB.
Tore,
I don't believe you're zapping and then refilling with data those tables. Did you really zap and then append from somewhere else that 950Mb table???
Cetin