>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 ?
No, you'll need the ODBC driver only on each client and it should already be there in a standard Win XP /Vista setup.
>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..)