Alright, I have a general problem happening on my site and I need some advice or suggestions. i can't seem to get my programmer to figure out what the issue is, and I suspect is is because we cannot duplicate the problem as we are not in the multi-user environment that my users are during the day.
My website is a software as a webservice program that manages business in an office. Each user has an individual account that they log in to, and files are shared as records in the system amongst multiple users. Multiple people can be working on the same file at once.
I am running Microsoft SQL and Windows Server 2K3.
Here is what is happening:
Data is being overwritten from one record to the next. A new record will be input, and it will take the data from the previously accessed record and merge with it. Sometimes, one user is just using the site and they click on a client name, and a record with a changed name appears in its place.
I am looking for any and all suggestions on how to troubleshoot this, or if there are common problems when something is not programmed in the correct way leading to records being overwritten in a MS SQL and Windows 2K3 server environment. My programmer can't seem to find the cause, so I am hoping I can get some feedback to help him.
Thank you.
My website is a software as a webservice program that manages business in an office. Each user has an individual account that they log in to, and files are shared as records in the system amongst multiple users. Multiple people can be working on the same file at once.
I am running Microsoft SQL and Windows Server 2K3.
Here is what is happening:
Data is being overwritten from one record to the next. A new record will be input, and it will take the data from the previously accessed record and merge with it. Sometimes, one user is just using the site and they click on a client name, and a record with a changed name appears in its place.
I am looking for any and all suggestions on how to troubleshoot this, or if there are common problems when something is not programmed in the correct way leading to records being overwritten in a MS SQL and Windows 2K3 server environment. My programmer can't seem to find the cause, so I am hoping I can get some feedback to help him.
Thank you.