1. You do not need SQL server 7.0 "on your network" you do need SQL server
driver on your PC (usually there from some other installation like
2. You cannot limit the database by application. You can limit it by your
application users, or you can create a generic id, and hardcode password in
> I am trying to develop an application that can connect to a SQL
> I am a newbie to SQL so please bare with me.
> 1) Do I need SQL 7.0 Server installed on my network in order to
> access a SQL database? ie. Access 97 is not required to use an Access
> 97 database. If not, then what do you use as the 'Server=' value in the
> connection string?
> 2) Is it possible to create a SQL database so that only my
> application can access it?
> Thanks in advance for any help,
> Shaun Planiden
phone (401) 742-1636
fax (520) 438-5537
Visual Basic, MS Access, Crystal Reports, SQL Server, and ASP independent
Development, system integration, database design and data conversions.