Why is Data Disappearing in Multi-User environment

Hi Experts,

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?
Thanks
SheritlwAsked:
Who is Participating?
 
zx10rConnect With a Mentor Commented:
Might be worth to check the setting on the SQL Express where it is working and replicate them on the full version.
0
 
zx10rCommented:
Can you provide more info on how the process works for retrieving the schedule information for each user? Maybe the code for the view as well.
0
 
SheritlwAuthor Commented:
The code is the same for each user.  The front end uses ADO to connect and retrieve data from a view in SQL Server.   Their is no binding so it is sql syntax that is sent to the server to retrieve the information needed from the view.
I don't know how the client has their SQL Server configured and since the program brought in all the data as a single user, but not when used in a multiple user environment, I tend to think their are some settings I need to look for.
The code from the vb front end is
Select * from vSchedules where scheddate = '" & dDate & "'"
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
zx10rCommented:
What about the code for vSchedules?
0
 
SheritlwAuthor Commented:
It is a view stored in SQL Server.  It is just like any view and works fine.
0
 
zx10rCommented:
I do not think this is a SQL issue if the view is returning correct data, that being multiple or single requests. Check the on the front end where the data is being displayed, it might be a problem there.
0
 
SheritlwAuthor Commented:
The strange thing is that in a single user environment the data displays just fine, it's only when multiple users are on the system the information doesn't get displayed.
0
 
SheritlwAuthor Commented:
Also, other clients use the program in a multi-user environment, but with sql server express as the backend and don't have any problems.
0
 
SheritlwAuthor Commented:
What settings should I check?
0
 
SheritlwAuthor Commented:
I did a webx with the client and found out they had a filter applied that would stop the information from show.  Problem solved.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.