>>>>>>>>>>>>I'm deloping apps on a network. The production version of these apps are looking for data on the development drive. How do I change the path that the Form's Data Environment looks for the data?
>>>>>>>>>>>
>>>>>>>>>>>Add code in Dataenvironment.BeforeOpenTables event
>>>>>>>>>>>local cDbcpathname
>>>>>>>>>>>select config && this is configuration table
>>>>>>>>>>>go top
>>>>>>>>>>>cDbcpathname=alltrim(config.dbcpname)
>>>>>>>>>>>thisformset.setall("database",cDbcpathname,"cursor")
>>>>>>>>>>>You can use this code if all DE.cursors are for dbc-tables. If you have free tables then you should modify this code to reset CursorSource properties.
>>>
>>>
>>>I need to modify this code to include both a DBC and free tables. I tried to use the AMEMBERS() command and put the properties and members of the Data Environment into an array. This obviously didn't work. Any suggestions?
>>>
>>>Thanks
>>
>>You should go through all DE.Cursors checking Database property first, if it's empty then you reset Cursorsource property, if not- reset Database property itself.
>
>
>How do you find the names of the Cursors?

=amembers(myarray,thisform.dataenvironment,2)