Here's the current setup. I have an APP that opens different versions of a database. Each database is located in a separate directory. I've been using :

CLOSE DATA
OPEN DATABASE (myDBC)
SET DATABASE to (myDBC)
SET PATH to (the directory in which myDBC lives)

The problem is , if the database table referenced in the forms DataEnvironment exists it will use this table instead of the one I want from the current Database setting. The only way to get it to use the correct table is to move the original directory referenced in the form's DE so Foxpro can't find the original.

The other option would appear to be load the tables manualy in each forms DE OpenTables method. This, of course, is a major drag!

Any other ideas ?