> Dear Expert,
>
> The native datafile, has become very very slow in access and indexing.
>
> 1. What additional tools do I need to incorporate in the program to speed it up?
>
> 2. What approach do I need to ensure that the data integrity is maintained, currently I'm seeing a situation
> where the various reocords are duplicating, tripilicating etc.
>
>
> The program is on a network, and when 3 or more users come on board, the program access becomes extremely slow
> and the next thing is that it hangs.
>

That does not sound like a VFP problem, but rather like optimization issues in your code.
When you for example say that indexing is slow, you might not want to do that at runtime at all, but once only, in the Table Designer, for example (Views are an exception, but they are not shared files).


hth
-Stefan