Blair,
You can
USE TheFormset.scx
and look at the properties field of record #8 and see which table is causing the problem.
It sounds like you are not getting the table closed correctly after it's first use. Are you using private datasession forms? Do you have SET EXCLUSIVE ON? Usually when things work one way in development and another in the app it's because of a difference in the SET environment. Your dev environment is controlled by choices you make in the Tools/Options dialog and runtime environment uses the VFP default values for all of the SETs.
You can look for differences in the output of a simple program:
display status to file c:\status.txt noconsole
compare the two files between your dev env and your app.
>I have a series of forms/formsets for entering data, accessed by a menu. With one "Problem Formset" I get the following: If I open other forms (and close them) and then try to open the "Problem formset" I get "Error loading File record 8 formset
>(or one of it's members) Parent, error loading the Data environment. Table in Use."
>
>However,if this formset is opened first when starting the app, it functions normally.
>
>All database tables are closed when each form is closed. This error only happens when the application is compiled as an app - it works fine in the test environment.