Hi!

Did you tried to close all connections to the VFP database and all recordsets, then open them again periodically? For example, do this each 10 or 100 requery attempts.

>Hello
>
>I am having a little trouble with an application I have created, and I am not sure what the big probelm is. If you could please give me some input, I would greatly appreciate it.
>
>I have an ADO recordset that connects to an Visual FoxPro Free Table (DBF). It has a LockType for Pessimistic and a CursorType of Keyset, though I think FoxPro drivers only support Static Cursors according to help. Once I open the recordset, I enter a DO... LOOP that issues Requery on the Recordset and DoEvents. This works fine through the day. Each morning when I go the check the application, it stops working properly. It seems as if the recordset has "lost sync" with the FoxPro table and no longer sees new records being added to it. I am certain that the application is not hung-up, and the application is hitting the Requery line for the recordset. The application works properly when shut down, and restarted by double clicking.
>
>The machine this application runs on is a bit old, and I was wondering if memory could be the issues. The machine has 32MB of RAM, and is a Pentium 200mhz. 5 MB of ram are free according to the system monitor while the application runs, and the CPU Usage % is constantly at 100%..
>
>Could running at a constant 100% CPU overnight cause this trouble? Does the machine simply need more RAM? I am thinkig that 256 MB of RAM would solve my problems.
>
>Any advice you may have is welcome.
>
>Thank you for your time and help.