>>Another thing you might want to look at is the GenDBC program in the Tools\GenBDC under your main VFP directory. This will automatically allow you to programatically generate the DBC and it's views. The code it produces can be used and modified to fit your particular situation.
>
>Hey George,
>
>I just checked it out... Am I understanding correctly that I can, once I'm relatively satisfied with my database structure, store the generated code in my application and then just modify it and resend just the EXE as needed? Updating tables, views, data, etc.? Without disrupting the client data? That would be way too cool...
>
Renoir,

In a word, yes. In fact, I use a similar strategy.