Hmmmm.......Do you have any grids, listboxs, or comboboxes where the rowsource is one of the big tables? That could be the slowdown. You could use views with NoDataOnLoad set to True, and then selectively requery.
>I have noticed that my form's instantiation speed is determined by the size of the files in the data environment.
>
>I have a form that has a table with 350,000 records and another table with about 200,000 records. When I issue the do form it takes 15 seconds for the form to load. If I zap these tables then it takes about 4 seconds.
>
>What is happening here? Is there some setting I can set to speed this up. I don't think my customer's are going to find this acceptable.
>
>Thanks,
>Paul
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05