> >
> > Thanks all for the reply,
> > I am still having trouble, I built the project and added the database in the project.
> > I have tried "set path = " in the main program. I have tried to set the "This.cursor1.database =" in the beforeopentables in the dataenviroment of the form. Nothing works. Please continue to offer advice.
>
> Hope I understood your problem correctly. If you are planning to run the application from different PCs on the LAN, you will be building an EXE file and deploying the same on a server or on every PCs from where it will be run. In that case you will be putting all the database and tables on a central location in server, accessible by all users. So why you have to include the same in project? I do not include the database in project but in the main program I set the path to the database and tables. Then I open the tables/database as and when needed in the program.
> Benny



I Found the answer - The database was part of the project because that is where I created it. Upon research I changed "beforeopentables" for each form to change the database location. What I did not realize was that in the project info the *.dbc was flagged as an included file. What that did was to make it impossible to change database locations. Once I removed the "include" flag from *.dbc in the project info and rebuilt the project, The "set path =" and "This.cursor.database =" included on each form worked. I am now able to specify a different database location. What I don't know how to do is to pick up a location from an .ini or config.fpw so that I can change database locations on site without rebuilding the project. I am curious, if I build a database outside of a project and open it in the main prg, can you use form wizard? What is your methodology for data sourcing in your forms and reports?

Thank you very much for your help and replies,

Mark Buckley