Viv,


>Can you clarify what you mean here. It sounds as if you expect to place a copy of a SQL database on the customers machine and access it via the VFP OLEDB drivers without an installed instance of SQLServer. You can't do that.

No, the accountant would have sql databases (accessed as a service) whilst the customer would have one or more sql databases with native/odbc access (sql - not VFP this is)
I'm planning to convert the foxpro databases

The folder structure would look like

root
    - cust_1
        - 2004
             2004.mdf
        - 2005
            2005.mdf
       ...

    - cust 2
       - 2006
            2006.mdf
       - 2007
            2007.mdf
       ....

    - ...

Does this make more sense ?

[ I have also thought about sql compact for the customers, but then I would need to maintain 2 database structures and pull data from one into the other]

____________
>Hi,
>Snips:
>The accountant would have an sql server whilst the customers would access the database with the native drivers.
>There are many customers - installing/maintaining an sqlserver service is not feasible in terms of work/problems
>
>Can you clarify what you mean here. It sounds as if you expect to place a copy of a SQL database on the customers machine and access it via the VFP OLEDB drivers without an installed instance of SQLServer. You can't do that.
>Regards,
>Viv