I don't know if it has something to do with different header file bet. FPW2.x and VFP. The table that I am using here was created purely in VFP. Try Opening the table in exclusive mode and then modify the structure? Other things of considerations like, REINDEX, PACK, SET DELETED ON, Tag on DELETED().

>Here are some numbers from some further testing.
>
>Hardware: Pentium 2 350, 64M RAM.
>Network: NT4.0 SP? (I am not the administrator)
>
>As below: Test from Command window:
>1. use blah
>2. go bott
>3. brow
>
>Slow speed happens in brow
>
>IN VFP.
>Table has 96,000 records. Indexes on 6 of 12 fields.
>Test 1: Nothing open.
>Brow took 0:27 to fully open.
>
>Test 2: Open DBC first.
>No effect on browse time.
>
>Test 3: Open an FWP2.6 table. 250,000 records.
>Browse took 1:07!!! to fully open.
>
>In FPW 2.6 Test 3: table open instantly.
>
>Any ideas?
>
>TIA,
>Mike
>
>
>
>
>
>>>Can anything be done to increase the speed of fox opening tables, and navigating them?
>>>
>>>In FPW 2.6 command window,
>>>use blah
>>>go bott
>>>brow
>>>works very quickly.
>>>
>>>The same set of commands in VFP are quite slow, i.e. 15 secs.
>>>
>>>Any ideas?
>>>
>>>TIA,
>>>Mike
>>
>>Sounds strange to me! I have a table with a million records, it opens in a blink of an eye. Post the exact commands, index available, how many records?