Anti-Virus software could be doing it... I've seen situations where the desktop is also scanning networked drives/locations and that can cause the problem you're having.
>I redid an existing form using a view to local (LAN) tables. The form uses 4 or 5 views all based on the serial number (C 8) of the parent record. Initial query openig the form and Requery is taking 5-6 secs on each view pulling data from tables with about 100,000 rows. I am surprised that it takes so long considering that there is an index on the field being used in the where clause. Have I overlooked something. Server is running Windows Server 2003 and there are only about 10 PCs on the network
>
>Thanks.
ICQ 10556 (ya), 254117