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
Gregory