Thanks to Doug Hennig's SetDataDirectory() method, I have resolved my Local Vs Network problem with DBCs. In some forms, however, I seem to run into something that defies my understanding of how things run/fire.

The error I get is: Error Loading file - record number x. frmUsers . ControlSource: Alias 'USERS'is not found.

I have AutoOpenTables set to False. In my Load, I call SetDataDir() and it changes the Database property of all cursors to my network DBC. I get the above error even BEFORE I reach BeforeOpenTables() !! I'm trying to see what exactly it doesn't like but I just can't seem to STEP it earlier than the error.

I have to add that the DE is a mixture of tables and local views.

Doug's solution worked fine on rather complex custom forms. It failed on simpler (user maintenance) forms that inherit a lot from a class. Regardless of any inherited code, is there any way to STEP thru code before this dreaded error occurs ?

Any ideas ?

Thanks

Henry