>You cannot access the data environment of a COM object from a client and vice versa. Can you tell us how you came up with that conclusion? <
If I open a table, change aliases, record pointer, etc., on one client it is changed on all clients.
oCom = CREATEOBJECTEX("MyCom.MyComClass","\\SERVER") && returns object ref.
*-* I have a method that executes and VFP command or function
?oCom.Exec("ALIAS()",.T.) && Returns current alias
?oCom.Exec("USE MyTabel") && or something like this - Returns .T.
here is my stripped down Exec function:
LPARAMETERS tcCommand, tlReturn
LOCAL lValue
lValue = .T.
IF tlReturn && get a return value
lValue = &tcCommand
ELSE
&tcCommand
ENDIF
RETURN lValue
George