Colin, Are you using the Data Environment in your forms? If so you need to tell it where to find the tables, usually in the form Load() method, with thanks to Doug Hennig and Whil Hentzen ... * * Set the path for the data cursor(s) in the data environment * thisform.DataEnvironment.CloseTables() thisform.DataEnvironment.Cursor1.database = oApp.cLocDataCur + ; "\name_of_database.dbc" * - repeat above for each cursor used in the form thisform.DataEnvironment.OpenTables() Note that oApp.cLocDataCur is recovered from an .ini file; it could be found using getfile(), however you want to do it. Hope this helps - Miles > > Hello all, > > I'm developing VFP5 apps on a Novell Network and have set up a > development/test environment on one volume (G:) and set up the live > environment on another (I:). I do this because many of the apps will use > the same databases and tables and I don't want to work with live data while > developing. > > My project, database, forms, menus, etc are located on G:. When I create > the EXE on G:, no problem. When I create the EXE on I:, it doesn't know > where to find the data. How do I make it use the data on I:? > > Thanx > > Colin Magee ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Miles Thompson CQA Consulting Group mthompso@fox.nstn.ca P.O. Box 82 Voice - (902) 883-1010 Enfield, NS Fax - (902) 883-8586 Canada B2T 1C6 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~