In the DE's .BeforeOpenTables put the following for each table and/or view:
THIS.Cursor1.Database='g:\docctrl\data\myDatabaseName.DBC'
THIS.Cursor2.Database='g:\docctrl\data\myDatabaseName.DBC'
etc.
HTH
>We have a somewhat wierd project. We need to have the app (exe) on a public directory and the data on a workgroup directory , ie w:\docctrl\docctrl.exe, with the data stored g:\docctrl\data\docctrl.dbc
>This is so each work group has their own data. In the builder, the default data directory is set to g:\docctrl\data, but in the data environment of the forms\reports it reads the path to the project working dir, and is not editable.
>How do we force VFP to write the correct path?
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.