Hi Lynda,

In my startup.prg I declare 2 public vars, gcSysDrive and gcDatDrive and then have the following...

gcDatDrive = User Directory     && Drive and path to this directory
gcSysDrive = startIn Directory  && Drive and path to this directory

*Delete old views from User Directory
*Copy views from startIn to User Directory (this way always got a fresh copy at each startup).

gcBaseDbc = gcSysDrive+'\base.dbc'
OPEN DATABASE (gcBaseDbc)
gcViewsDbc = gcDatDrive+'\views.dbc'
OPEN DATABASE (gcViewsDbc)
SET DATABASE TO (gcViewsDbc)

This all works fine providing you have the local views in the same directory as your forms when developing. When attaching tables to the DE of the form, make sure these local views are the only ones open and that the tables are added from this .dbc only.

My development heirarchy is...
drive
DevelFolder (copy of local views,forms,menus etc)
DataFolder (views,tables etc)

My guess is that you are still using the views in the DataFolder, this can be checked by opening the DE and checking the value of the Database property for a view.

I hope this helps.

Regards
Doug Johnston



>Oddly enough, this is >exactly< what I tried to do except that the app continues to use views.DBC from the StartIn (shared) directory at the client site rather than the copy in the user directory. (The user directories are on a network drive -- neither Target nor StartIn -- because there are Citrix users.) This happens even though main.prg creates the personal copy of views.dbc (if necessary) and opens it. The StartIn directory at the client site does have the same relative path as at the development site and this is the path hardcoded into each form's DE. I'm afraid to delete the shared copy for fear the app won't run at all.