View Full Version : Simultaneous users can't see each others data


patrickd123
03-04-2007, 03:40 PM
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
03-05-2007, 08:48 AM
you need to provide more information...

what kind of system is this?

what is the front end?

what is the backend?

patrickd123
03-05-2007, 02:36 PM
I am running an ADP connecting to an sqlserver database on a remote web hosting service

SQL_Hell
03-07-2007, 04:51 AM
You need to refresh the form, so it re-runs the query

patrickd123
03-07-2007, 08:33 AM
Ok, I will try me.refresh and give news on that

Thanks