>Hi,
>
>I've developed an application that uses a VFP front end, VFP Middle tier and SQL Server 2005 backend. The data collected includes contact information and now my client is asking if we can interface ACT or MS Dynamics CRM (or some other CRM software) with our application.
>
>Has anybody any experience doing this? Is it as simple as point ACT! or whatever at my database and telling it this field is the email, this other one is the address and this third one is the person's name?

I've worked on Act with another client who originally had the MS Dynamics, and it choked on performance... almost 10 minutes (no exaggeration) before the initial screen would present itself.

As for working with ACT!, I don't remember which version they had, but the only way to get at the data was by using a third-party (by Stonefield) to get at the data as it was on SQL... Something about they way they locked down the database, tables, etc.

Good luck