Simultaneous users can't see each others data

[patrickd123]

Hi,

We have 1000 contracts to update information in. I have a contract form that 2 users use simultaneously to do so. The problem is that each users can modify a record, go to the next one, come back and see that his changes are still there but if user B happens to cycle through one of the contracts modified by user A, he does not see the changes unless he gets out of the form and re-enter in the form.

Any idea how to overcome this problem?

Thanks

 

[SQL_Hell]

you need to provide more information...

what kind of system is this?

what is the front end?

what is the backend?

 

[patrickd123]

I am running an ADP connecting to an sqlserver database on a remote web hosting service

 

[SQL_Hell]

You need to refresh the form, so it re-runs the query

 

[patrickd123]

Ok, I will try me.refresh and give news on that

Thanks