Hi,

>>
Is is possible to change what the location of the tables are using the data environment depending on how an application is ran.
>>

Here's a bit of generic code that I run prior to DE.OpenTables() occurring; gcDataDirectory being the required path:

LPARAMETER theDE,theDB
LOCAL lnCount,loObject
LOCAL ARRAY laMembers(1)

IF AMEMBERS(laMembers,thede,2) > 0
  FOR lnCount = 1 TO ALEN(laMembers,1)
    loObject = EVAL("theDe."+laMembers(lnCount))
    IF UPPER(ALLTRIM(loObject.BaseClass))="CURSOR"
      loObject.Database = gcDatadirectory+thedb
    ENDIF
    LoObject = .NULL.
  ENDFOR
ENDIF

HTH,
Viv