>I am about to embark on a new adventure- converting a FoxDOS 2.5 application used by many many people to VFP6.0. At this point I am not sure whether I should use the DBC or not. I can code for referential integrity and having code hidden in triggers etc does not exactly turn me on. Aside from updatable cusors and transaction processing are there any other advantages to using the DBC versus free tables? On the other hand are there other disadvantages to the DBC other than the risk that it gets broken and the application will not work?
>
>I would appreciate any input you can give me. The typical user is either a single machine or a small peer to peer network.
>
>Thanks...

Along with the others, you can run GENDBC.APP in the TOOLS\GENDBC directory of VFP. This will create the code needed to recreate your DBC if anything goes totally wrong. The drawback to this is GENDBC bombs at a certain DB size. I don't know exactly waht the upper limit is.

You could also check products such as Stonefield Database Toolkit & Utilities to better manage your DBC, tables, indexing, table repair functions, etc. For the price, it has been $ well spent, IMHO.