Any solution will have to deal with users access to the database. SQL server
allows you to define roles for specific groups of users. So in this case it
is possible to grant them read-only access for one particular table.
----- Original Message -----
From: "Nanda Kumar" <nandu@n...>
To: "Code Clinic" <proasp_codeclinic@p...>
Sent: Thursday, May 24, 2001 5:36 AM
Subject: [proasp_codeclinic] RE: proasp_codeclinic digest: May 23, 2001
> Thank you Gerhard. But giving users a direct access to the database is not
> good idea and could be dangerous too. So, is there anyway, we relpace a
> specific content in the document with the data from the database?
> Thank you again for the help
> Subject: Re: help on data merging in winword using asp
> From: "Gerhard Wentink" <data@w...>
> Date: Wed, 23 May 2001 10:33:25 +0200
> X-Message-Number: 2
> I was struggling with this question, too, a few weeks ago. This is what I
> found out till now:
> I asume that you want to get the data from a database that resides on a
> remote server.
> That means you have to*talk* with the database over TCP/IP.
> As far as I know there is not a simple way to do this with an access
> With SQL server however its not a problem. In office 2000 you have to make
> ODBC connection to the SQL server on the remote machine. Then make a merge
> in Word with MSQuery.
> In Office XP you can make a office data connection to the SQL server.
> Gerhard Wentink