2. ASPRunnerPro General questions
  3. user's ability to edit records
This topic is locked

user's ability to edit records

 		6/17/2004 2:37:57 PM
ASPRunnerPro General questions
M
 mutiny author

I was just wondering if I can disable the ability for a user to even edit their own record once its entered into the database and only the admin have the rights to edit. also, is there a way to add some kind of flag or * mark next to the record that has been editted by an admin? please help. thanks
Sergey Kornilov admin 6/18/2004

I guess you can mark all records belong to an Admin user (via a hidden field on the Edit page). In this case only Admin will be able to edit records.
Also you can add a boolean field named IsEdited which will be set to 'No' when record is created and will be changed to 'Yes' (via hidden field again) when record is edited.
I hope this helps.
M
 		mutiny author 6/18/2004

Do you mean the "edit page" in ASPrunner? or in the ..._edit.asp? and if its in asprunner, I couldn't find the function to assign records to the admin user? please explain. Thanks!
Sergey Kornilov admin 6/18/2004

You can do this in ASPRunner.
Probably I can provide you more help if you zip and send your sample database and your project file to support AT xlinesoft.com.
Just in case here is the basic idea:

  1. You need to use Advanced Security option named "Users can see other users data; can edit their own data only". On this step you pick OwnerID field.
  2. You should note what is the UserID of the Admin user.
  3. You should display OwnerID field on the Add page as a hidden field and assign default value to this field equals UserID of the Admin user.
    In this case all added records will belong to an admin.