>>>We are using Codebook framework with both pre- and runtime defined local views in the databases. It seems, however, that in multiuser environments our runtime
>>Your hack will work untill the user decides to move the tables DBC to another place. Other than that, it seems fine to me. There are several interesting subjects that are discussed in the wiki of www.foxforum Check http://www.stevenblack.com/wiki/wc.dll?wiki~CreatingDBCforViews first.
>>
>>José
>
>Many thanks for you reply Jose - especially your hint about Steven's place was very valuable.
>
>Unfortunate our hack didn't work so well we hoped. We succeeded to change the directory at runtime (which was, in fact, one of the original needs for the hack), but only if TablesDBC was only one directory below ViewsDBC. If there were more subdirectories included or TablesDBC was situated in a totally different path, VFP couldn't open/find individual tables. Obviously the path information (or some other essential fact) is compiled also somewhere else and because that information remained unchanged, VFP couldn't work as we expected.
>
>At the end we solved the situation by creating all views from scratch every time we need them. Because we rejected VFP's graphical view designer, the maintaining of the views will be hard, but we have to adapt to the situation. Our application is also slightly slower than before - but, it works.
>
>Regards,
>Ilkka

Thanks for telling about your findings Illkka. This is something I never did myself, so I can only guess what's happening.

I'm pretty sure Ed Leafe implementation was to have the views in a local DBC (I mean on a local drive) and the tables within another DBC on the server. The best place to find Ed is on the Codebook forum. You might want to sum up your experience and post a message there. (www.codebook.leafe.com). And once you get everything fixed, sum up your experience for the wiki.

José