Hi all. I have been getting so frustrated because I have built 10 views based on tables contained within a .dbc in my test work area.

Well come to find out when I run the .exe in another directory, it is using the tables from my workarea.
Also, the views are also using these tables. (Not good...)

How in the world, do I point the .exe to look at the tables in the .exe directory? Do I have to build the views all over? I can open the DATABASE and delete the table from there and add the new table (in the .exe directory) but the view is still based on (looking at) the table in my workarea.

What has to be done to the views and tables within the 'live' directory, so that my grids work? The recordsource for the grids are the views built in my workarea....When I run the program in a different directory, I want the .dbc to point to the tables within that directory, and the views within the .dbc to use these tables as well.

please help
Angie