how can I allow user to edit BUT NOT delete the records in a view?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all,

Could anybody tell me that how I can allow user to edit BUT NOT delete the
records in a view?

I know there are only 3 options when opening a view:
Add (the user can add new records but can't view or edit existing records),
Edit (the user can view or edit existing records and add/delete new records),
or Read Only (the user can only view records).

The Edit mode will enable Delete command. The delete command is very
dangerous. The users may accidentally delete all the records without
receiving any warning at all. But if I choose to open the view as Read only,
then they can only read but not edit the records.

Does anybody have any idea about how to allow user to edit BUT NOT delete
the records in a view?

Thanks a lot!
 
I should have made it more clear. Actually, I have a macro, the action for
this macro is 'OpenView' which open a certain view in the SQL server. But I
know there are only 3 options when opening a view:
Add (the user can add new records but can't view or edit existing records),
Edit (the user can view or edit existing records and add/delete new records),
or Read Only (the user can only view records).

Could anyone describe in details what's the fastest way to allow user to
edit BUT NOT delete the records in that view I opened in my macro? Thanks
again!
 
Oldmonkey,

Generally it is inadvisable to allow users access to any datasheet. It
is better to open a form based on the query/view. Forms are the objects
whose purpose is the entry/editing/viewing of data. In a form, you can
set the Allow Deletions property as required.
 
Thanks, steve. But in the form, user can only see one record, but they want
to see a lists of the record, that's why I use the view. Do you have any
advise on how to set the access control on view (let them edit but not delete
records).
 
Oldmonkey,

I would recommend a form in Continuous View. This is controlled via the
Default View property of the form, or if using the Form Wizard to create
the form, select Tabular layout.
 
Back
Top