Randy,

On desktop apps I don't create the copy, I just check the local version against a network copy. Good idea about having each com server have it's own views DBC. For now I think I am going to wait and see if it becomes an issue. I have also heard about the new VFP7 CONNSTRING command which according to JR (JVP's nemesis) could solve the contention issues.

Kevin

P.S. Can't wait for the hard copy of the WebRAD book!


If you run into contention issues, it is still possible to create a scheme where each COM server has its own DBC as well. Basically it's often helpful to think of each COM server as a "user".

I assume you have some reusable code to create the DBC copy when an app starts up. One approach might be to create a little table of instances where there is one record per instance. Each record corresponds to a subdir where a copy of the DBC can be made. So, let's say COM server #3 starts up. It traverses the little table looking for a record to lock (sort of like a semaphor). If it locks record #3, it also uses subdir .\dbc_copies\3\ for example.