We did something like that a few years ago. The way we addressed this issue was by using SQL Server on the server and MSDE on the workstations.

Users that are connected to the network read and write data from SQL Server. When users go traveling, then they read and write data to the database stored in their hard disk via MSDE.

MSDE and SQL Server are completely compatible. We didn't need to change any of our views and/or SQL pass-throug statements. The only thing that we do to switch from local to remote is to change the connection string to point to either local MSDE server or the SQL Server on the server.

Hope this helps.

>Hi there.
>
>I have an application in Fox2.6 which I will convert to VF7
>with CodeMine. One important feature I need is the ability to pack it ready
>for customers who will choose to work with the native Fox database (local
>views) or SQL. Is it possible to have only one project giving me this
>option ? I mean, not having one to work locally and another version for
>remote.
>
>Thanks.