>>I have been involved in a couple of projects like that. One was a massive commercial application and yes, it was that simple to start >>with. But anyone new to sql server i.e. you and some of your customers, start to hit issues. Some purely learning curve ones >>others just sql server issues you either didn't know or you could have done differently. It too way too long to deliver and >>commercially speaking it was a bad decision. It's still wrapped up nicely sitting on the shelves. It offered great experience.

>>The second project was smaller, less than 20 customers, we had alot more control in terms of going in to sort issues. Not too >>much conflicts with corporate procedures. It's been great.

>>I know there is usually a business requirement to solve a problem here and now. But in the idea world, I would invest into the future >>technology.

Thanks Mathias,

With the exception of a couple of clients we have a close working relation ship and 90% of our clients have no IT department and no IT support other than us. Idealaly I woudl like to keep the VFP tables version for single pc and peer to peer sites and only use the SQL back end for larger sites, is that possible?

Regards

Gary.