"slickbet" wrote:

> I am using Frontpage 2002 on a Win 2003 server.  I used the Database Results
> Wizard to create my pages using ASP.  Everything is working fine, I just
> don't know if it's possible to do what I'm needing.  I have a search page
> that brings up results that contain a link so that individual records can be
> viewed.  There is an edit button on that page to allow the user to make
> changes to that record. The issue is, while they need to view all the
> infomation in the record, I only want them to be able to edit 2 fields.  I
> tried elimating the other fields from this edit page but once the information
> was entered all data for that record was moved into the 2 editable fields. 
> If anyone know of a way to allow all fields to be viewed but only some to be
> edited, I would sure appreciate your help.
>

"jz" wrote:

> Question, please, if you don't mind?
>
> I was just wondering how you are setup to let users edit their own records. 
> I take it that they have to login, correct?  And if so, do you have to assign
> the username and passwords?
>
> Thanks. 
>
> "slickbet" wrote:
>
> > I am using Frontpage 2002 on a Win 2003 server.  I used the Database Results
> > Wizard to create my pages using ASP.  Everything is working fine, I just
> > don't know if it's possible to do what I'm needing.  I have a search page
> > that brings up results that contain a link so that individual records can be
> > viewed.  There is an edit button on that page to allow the user to make
> > changes to that record. The issue is, while they need to view all the
> > infomation in the record, I only want them to be able to edit 2 fields.  I
> > tried elimating the other fields from this edit page but once the information
> > was entered all data for that record was moved into the 2 editable fields. 
> > If anyone know of a way to allow all fields to be viewed but only some to be
> > edited, I would sure appreciate your help.
> >

"slickbet" wrote:

> First off, I made the subsite so it does not have anonymous access.  Only
> users with permission can access the site.  We are running Microsoft Active
> Diretory so they don't actually have to login.  It knows by their pc login. 
> Then I used the Database Interface Wizard to set up all my pages. I included
> the Submission Page, Results Form and Database Editor.  Once I completed the
> editor, I went to the results.asp page and made the ID column into a
> hyperlink.  That puts a hyperlink on each record when it comes up in the
> search.  I made the hyperlink go to editadd.asp?ID=<%FP_FieldURL(fp_rs,"ID")%>
> The editadd.asp page was created with the wizard.  That brings up a page
> that allows them to edit all fields. 
> Hence comes my problem.  Since I didn't want my users to edit all the
> fields, I tried omitting the ones I didn't want them to edit from this
> editadd page.  That messed up the records that were changed in the database
> as it moved all the data in that record into the fields they were allowed to
> edit.  The other fields were left blank.
> I hope this answers your question.
>
> "jz" wrote:
>
> > Question, please, if you don't mind?
> >
> > I was just wondering how you are setup to let users edit their own records. 
> > I take it that they have to login, correct?  And if so, do you have to assign
> > the username and passwords?
> >
> > Thanks. 
> >
> > "slickbet" wrote:
> >
> > > I am using Frontpage 2002 on a Win 2003 server.  I used the Database Results
> > > Wizard to create my pages using ASP.  Everything is working fine, I just
> > > don't know if it's possible to do what I'm needing.  I have a search page
> > > that brings up results that contain a link so that individual records can be
> > > viewed.  There is an edit button on that page to allow the user to make
> > > changes to that record. The issue is, while they need to view all the
> > > infomation in the record, I only want them to be able to edit 2 fields.  I
> > > tried elimating the other fields from this edit page but once the information
> > > was entered all data for that record was moved into the 2 editable fields. 
> > > If anyone know of a way to allow all fields to be viewed but only some to be
> > > edited, I would sure appreciate your help.
> > >

"slickbet" wrote:

> I am using Frontpage 2002 on a Win 2003 server.  I used the Database Results
> Wizard to create my pages using ASP.  Everything is working fine, I just
> don't know if it's possible to do what I'm needing.  I have a search page
> that brings up results that contain a link so that individual records can be
> viewed.  There is an edit button on that page to allow the user to make
> changes to that record. The issue is, while they need to view all the
> infomation in the record, I only want them to be able to edit 2 fields.  I
> tried elimating the other fields from this edit page but once the information
> was entered all data for that record was moved into the 2 editable fields. 
> If anyone know of a way to allow all fields to be viewed but only some to be
> edited, I would sure appreciate your help.
>

"Bruce Dill" <BruceD***@discussions.microsoft.com> wrote in message
news:F6728E71-EA99-485C-A17F-3DA24FF295FC@microsoft.com...
> Good Afternoon.
>
> I read your message as I am about to input security into my FP 2003
> website.
> I also need to be able to allow users to change data in the Access files.
> I
> used DWR to list records but don't know what to do to edit them.
>
> Thanks
> --
> Bruce Dill
>
>
> "slickbet" wrote:
>
>> I am using Frontpage 2002 on a Win 2003 server.  I used the Database
>> Results
>> Wizard to create my pages using ASP.  Everything is working fine, I just
>> don't know if it's possible to do what I'm needing.  I have a search page
>> that brings up results that contain a link so that individual records can
>> be
>> viewed.  There is an edit button on that page to allow the user to make
>> changes to that record. The issue is, while they need to view all the
>> infomation in the record, I only want them to be able to edit 2 fields.
>> I
>> tried elimating the other fields from this edit page but once the
>> information
>> was entered all data for that record was moved into the 2 editable
>> fields.
>> If anyone know of a way to allow all fields to be viewed but only some to
>> be
>> edited, I would sure appreciate your help.
>>