Hi Jim, thank you for your interest in my issue.
What do you mean by TEMP and SORTWK? and how can i find them?
Ram are standard pc133 dimm and they range from 128 mb to 512 mb.
The software is a compiled software installed using a installshield.
First: i have a domain controler running SBS, active directory, win2000 server. I have users, many users.
Second: i have the workstations, they range from p2 400 128mb to p4 1.6 512mb.
I go on any workstation and i log with the user, let say "John". I start the FoxPro software .exe and i do some work and the software respond not correctly. I explain:
I have to enter some data in fields and the data is validated as i exit the field. Let say i enter "10" in "seq.no". 10 is a good number i know it. When i exit the field, a box popup saying that the data is invalid and show me what data are possible and "10" is in the list. so i re-enter "10" and the message still there. So i tried another number that is in the list. let say "2" and guest what, it did the same thing, the same message.
THEN
I go on the same workstation and i log with the user, let say "Mary" (she has the same rights and permission as John). I start the FoxPro software .exe and i do some work and the software respond CORRECTLY!
I go in the same form, i enter "10" into the field "seq.no" and i takes it and all is fine.
I reindexed all the tables but it didn't change anything.
I'm pretty sure it's not a permission or network problem because both users have full rights to the directory that contain the database and if i want i can delete the database, copy it, etc... so it means that i have full access (right?).
Thank for paying attention and i hope you have some ideas!
Diane Robitaille eng.