Why is Data Disappearing in Multi-User environment
Posted on 2008-06-18
I have a strange situation going on and really need your help.
I have a scheduling app with a VB 6 front end and a sql server 2005 backend.
When using the program as a single user all scheduled appointments are displayed, but when using in a multi-user environment some schedules don't show. The client says it is random.
I have checked on my machine with their database and front-end and nothing seems to be wrong, but this is as a single user.
The schedules to be displayed is retrieved using ADO and a view, there is no binding. Is there some setting in SQL Server that needs to be checked, or some other thing that could cause this to happen?