You can use Remote Views (RV), CursorAdapter(CA) or SQL Pass-Through (SPT).

>I have set up Sql express on a server, and attached a Database from my development machine, an am using Sql Server Express Mangagement studio to access it..all working fine.
>
>I now need to give access to it from a VFP APP that will be accessing it over a LAN , and am unsure what connection string to use, or the best way to do this. I have initally set it up using Windows authentication... is this the usual type of security for SQL databses?
>
>In SqlExpress mangemnt studio, the following are set up:
>Server Name = MySRV/SQLEXPRESS
>Using Windows Authentication
>