>>I ran a test last night with 32 bit client (2.5. It was going to ad about 400,000 records to a table with inserts. I am running on a pentium 300 with 64 MB , windows 98, and 32 bit client 2.5. I left it at 6:30. When I got back in this morning, my machine was completely hung. (key strokes just beeped) I rebooted and tried to open the table. Guess what??? INDEX DOES NOT MATCH TABLE….. CDX file size was 0K and the dbf was 1 K.
>>The network guy here said that I was locked because I was logged off at midnight.
>>This process took 1 hour locally. It should have been completed.
>>The client has caching turned off and true commit turned off
>>
>>Help!!!!
>
>John,
> I can't explain why your inserts didn't work but your machine should not have hung because you were booted from the network at midnight. The 32-clients have persistent connections to the network, which means that as soon as the server is available to the client again your client will reconnect it. I can think of only two reasons why your machine hung, 1. The program was running when you were booted from the network, or 2. Your program has bugs in it. To test 1. and 2. I would reduce your dataset and see if it succeeds and what kind of times you are getting for it. Hope this helps.
>
>Mark

On the 3rd attempt it worked. The second one failed at 10%. I had to reboot again. 10% should have been around 40,000 records. When I reopened th table, it only had 62 records. Where did they go??? As to the program.... no bugs.

Thanks
John