My application is an .exe file with a MAIN program and menu. Some basic questions:

When VFP 5.0 looks for a table to open, and there are multiple tables having the same name in the Foxpro path, is it true that a table in the default directory has priority over another table with the same name that is elsewhere in the foxpro path?

Is it true that every form and report with a private data session opens the database container when it fires up? Or is it possible to open the dbc once in program MAIN and let that dbc dictate what tables are available to subsequent forms/reports? I want tables in the default directory to be ignored sometimes. If each form, report, and label program initiates Foxpro table searches upon startup, what is the best way to specify something other than the default search heirarchy?

In the project designer, when I highlight the name of my database, the dbc's location appears at the bottom of the designer (in un-docked mode only!?!). Does this location have anything to do with where Foxpro searches when a form fires up from the compiled (exe) program?

Thanks!