This is to help anyone who has this Record Retrival Error problem.
I have been working on this for quite a while
and have been extremly fustrated by this as
I have not had many replys on my post and i have
clients screaming for the new Update.
Finnaly I have found my Problem.

When test my app on a network I used 20 to 50 records
All worked well the problem did not occur untill i used over 500 + records.

What caused the problem was I was doing a record count on the browse
As I was doing this every 6 to 8 secs the table could not handle the
retrival of the data
therefore the Error. Removed the record counter on the browse and no more
error.

I hope this helps someone if they have this problem.

Regards Sam