Hi Lynda.

>An application that is being converted to SQL Server 2000 shares some data with the client's AccPac accounting system. The accounting system's data is in VFP7 tables contained in a VFP database. The editing of SQL data will primarily be accessed through parameterized remote views stored in a single DBC. What's the best way to handle access the AccPac tables for editing? Can the views of AccPac data be included in the same DBC?

Yes. A view is just a pre-defined SQL SELECT that creates a cursor. Updates to the cursor can automatically be written to the source tables if desired.

> Any tricks to handling the updates of the AccPac data?

Nope, no tricks -- just make the views updatable and be sure to set the key fields property of the view correctly.

>Also, I read in another thread the suggestion that each user have his own copy of the DBC containint the views.

The reason for that is to prevent concurrency problems when two users open the view simultaneously. However, starting in VFP 7, you can use the SYSTEM clause of the SET REPROCESS command to eliminate the need to do that.

Doug