>I have an application that I used the application wizard to create. I have 3 forms in the app, two of the forms have data environments. The first form, the qckstart form can be run simultaneously by many people. The other two cannot. I am using table data buffering, tables are auto-opened and auto-closed, when the form is running it says at the bottom "record unlocked". In the data environment, all the tables have exclusive set to .f., I also have SET EXCLUSIVE OFF. Where have I not looked, is it the form itself that's the problem? Also, this app exists completely on the server. I've compiled it into an .exe and that doesn't help either. (As a side note, why do we have to have the forms, menus, and etc in an executable? Is this just a feature of the application wizard? I've converted other apps from 2.6 that don't seem to have this problem, but this is my first fully VFP app.)
>
>Thanks!
>
>Laurisa Watkins
>Seattle Parks Dept.
>laurisa.watkins@ci.seattle.wa.us

Laurisa, are you using Private data sessions? If not, the default setting for the global data session is EXLUSIVE = ON. Put the SET EXCL OFF code into your LOAD method on each of the forms to be sure it takes effect.

Also, are you using Pessimistice buffering? If so, then the records are locked as you load them to edit. Try switching to Optimistic Buffering to see if this solves your problem. If so, then you can look at editing/update needs to find the best approach.

As for compiling forms, menus, etc. into the EXE: It is not required, but any file NOT compiled into the EXE will have to be distributed with your application. Most people include forms and menus, but many do NOT include reports (OK, folks, let's not start an argument on this one). You can even include lookup tables that you don't want the user to EVER change.

HTH
Barbara