I am using VFp DBC to work with many different tables and view into a SQl 2000 database.

It works very well and I have had no problems, but the DBC is getting big.

Question: Is ther a suggeted MAx number or remote view for a DBC?

Is it better to have seeral smaller DBC as opposed to one large Dbc?

I actually compile the DBC into my apliation EXE because the users never need to change the DBC table structure. If they need to change structure, I just copy stru on a give view to a DBF and make ny changes there then delee it.

THANKS