>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?

If moving to Dotnet and fileDB is a pattern sometimes making sense (it does from the above...) you might look into advatage db server for accessing your tables either as DB server or file server.