>Forget about that approach, you are only creating problems for yourself. Either you follow some of the tips I gave you, or you use for instance MSSQL server as data storage. I do the latter, it's much more stable, it's faster with many users and it's expandable. I now only use DBFs for some lookup tables which I include in the exe, for everything else I use SQL server and cursors.
Now you're talking!
>
>>Sir,
>>While Searching on Google I found some Information on how to increase the data size over 2GB, but dont have still Evaluated that. Here is the link.
>>
>>
>>
http://devzone.advantagedatabase.com/jeremym/fox_large/foxprolarge.html>>
>>
>>AND
>>
>>
>>
http://devzone.advantagedatabase.com/dz/webhelp/advantage10/index.html?devguide_connecting_to_advantage_using_the_advantage_odbc_driver.htm>>
>>-------------------------------
>>
>>
>>
>>>>Is there any simple way to enhance the Limit of VFP DBF table beyond 2 GB Capacity ?
>>>
>>>Follow a few round rules, and this will not be any problem for a normal size application.
>>>
>>>1. Never use general fields. NEVER!!!
>>>2. Never store pictures in tables, only the name of the picture file, with or without path
>>>3. Normalize the tables, don't add fields which are seldom used.
>>>4. Reuse deleted records
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________