In my .dataenvironment I do not AutoOpen the tables and views. In my baseform.Load I scan thru the cursors determining what each is and assigning different paths or databases to them if required. This allows me to use local tables or views for development and only use the actual data when user is working on them.

I now have a form with two views. When I run the form on my computer using either the .app or the .exe file and the working data there is no problem. Everthing works. However when a user or client runs the form from the same .exe file the Baseform.Load works down to
= .dataenvironment.OpenTables().

Here the computer freezes and you have to go to task manager and crash FoxPro.

No error messages - nothing.

I can "use" the views in the load method before this point and have no trouble. I only have a problem when I fire .dataenvironment.OpenTables() and then only from one of my user's computers.

Of course I fire .dataenvironment.OpenTables() to get the proper relationships. However in the problem form there are no relationships between the two views.

This is a very old application going back to the dBaseII days. Data Files for each contract are stored in a separate directory for that contract. All tables are free tables type since we wrote (years ago) our own database container / metadata system.

I am experimenting with views to allow us to put this data on an SQL server. This is being done not to be trendy but to allow the data to be used with another SQL based application we have purchased.