I am using VB with foxpro to insert records via ADO object, using recordset.

I am getting error after inserting exactly 256 records everytime.
And it breaks by giving a runtime error message "Too many variables"

Records are inserted one by one in the for loop.

I searched on internet i found the following mentioning about MVCOUNT.
Fox pro has a limit for variable maintenance, is it possible for me to clear the MVCOUNT for each round in the loop.

I am not at all familiar with MVCOUNT.

Please if any one knows how to clear the variables which are maintained by foxpro while i run my program.
because i have lot of records to be inserted to foxpro dbf table. via for next loop.

Thank you very much.