Thanks for your replies.

I was trying to get clarity on the connection string to use and what security rights are required.
Currently, I have Sql Server express installed on a Server, and users will need to access Sql server from a PC on the Lan, via a VFP app.

Do I need to:
1. Install SQL SErver Express on each PC on the Lan ?
2. What connection string do I need
(Do I refer to the Server Name, Ip Address, or Drive letter for each Pc on the lan that is accessing Sql Server Express table on the server via the VFP App..)
3. What security is the best to put in place ..windows or Sql Server ?

This is the first VFP app accessing SQL server data so any pointers would ve appreciated.
regards,
Gerard






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