This sounds more like specific user or foxpro issues. I would delete all temporary files on the workstations, delete the foxuser.dbf (wherever the user's foxuser.dbf is located) and verify the location of the TEMP and SORTWK like Jim recommended (I would definitely make them separate locations for each user too). Also, users do NOT share the same foxuser table, correct? Also, can you post (if you haven't resolve it yet) here so everyone can see it and better help? The code that does does the validate in the seq.no field would be best whether it is in the valid or lostfocus method or a business rule, or where exactly?

I could be entirely wrong, but that is what I recommend (at least for troubleshooting purposes).

As for the settings Jim mentioned, I set them in my config.fpw file for all of my users. They all use locations on their local hard drive regardless of where the data is located, like below:

Here is an example of our config.fpw:

MULTILOCKS=ON
EXCLUSIVE=OFF
MVCOUNT=4000
RESOURCE=c:\FOXPRO\RESOURCE\foxusr7.dbf
MEMLIMIT=80,2048,2048
EDITWORK=C:\FOXPRO\TMP\
PROGWORK=C:\FOXPRO\TMP\
SORTWORK=C:\FOXPRO\TMP\
TMPFILES=C:\FOXPRO\TMP\
CODEPAGE=auto

Tracy

>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!