>Well time is money. If you spent 100 hours working on replication in VFP (I doubt you'd have much to show for it after 100 hours, but it's a nice round number) at $50/hour that's $5,000 in programming time. I think that's a very conservative estimate. I think the unlimited user license of SQL server is about $27,000. I'd be surprised if you could write a reliable, flexible replication tool in VFP for twice that even if you only used one of the many approaches SQL Server offers.
>
>>Hmmm...just took a look at the SQL Server pricing, wait and see I think.

I agree. In a perfect world, I'd also be using some sort of SQL server. But there are definately cases where SQL Server is just too expensive, or when you need to add replication capabilities to an existing VFP program. I'd venture a guess and say a lot of VFP apps would take a significant amount time to make it work with a SQL server - that's, of course, based on the assumption that the programmers didn't plan ahead using views, etc.

I'm in that boat right now. I would need to buy 10 copies of SQL Server (only 10 users at each site) plus do a near complete rewrite of their software to make things work. I think a product like FoxAudit and a bit of custom programming is going to fit the bill nicely. Granted, replication will only be in one direction - but that's all it calls for in my case.

Having said all that, good luck getting two way replication to work well under VFP ;-)

-Paul