> >
> > 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

Mark,

I always keep along with EXE files on the cuser's local drive, a small table which has a feild indicating the location of data files. At the first run, since this field is empty, application will ask the user location of the data files and store the same in the table. At any time in future, if the data moved to some other location then the system will again ask the new location, as it cannot find the required data files in the specified location. As Stefan told you, I also do not use Forms Wizard to make the form. All required tables are opned through code in the load method of the form.
Benny