Disable record deletion

S

Scott

I would like to set up the table that disable the record deletion. Once the
record is added, contents of the records are allowed but the records cannot
be deleted. Is it mission possible and how to do if so?

Thanks,

Scot
 
M

Maurice

Scott,

It is not good practice to disable the table from anything. You have to use
a form eg in datasheet view where you can set the different properties, One
of the options is allow deletions which you can set to no. Don't present the
end users with the tables or databasewindow.

hth
 
A

AuldMannie

Agree with Maurice.
Suggest you use a "Deleted/Disabled" field (boolean ((Yes/No)) in your table.
Have a query that Selects only records with this field set to No (False) as
the norm for your Form.
A User could then be able to update this Field on the form (if you let
them), to "delete" the record.

Just a wee thought - hope it helps.

Cheers
Auld Mannie
 
A

AuldMannie

Yes I actually use it all the time. Mainly for lookup tables. Data held on
Tables
referring to Lookups for 10 plus years e.g. User Id recorded against many
rows held, for Audit purposes and staff are mobile. Can only delete these
once the main file has no reference to any lookup used.

Maintenance no big deal SOP or System Standards whichever you wish to call it.
Plus so far it has only been me doing it. I run with full "test" backend
databases for testing development and the users only get .mde front ends to
run against the "live"
databases.

Do appreciate the point though. It requies discipline.
 
A

AuldMannie

Each to his own - no multiple views to data, no query merges to pick up
historic data, and all reports based on date from - to, records on a table
than need to be deleted can and are deleted along with their related records
on other tables. Some
tables contain records that should not and cannot be deleted. Dcount takes
care of records that can be deleted from those tables - i.e. the record has
been created but has never been used in any of its relationships. However
your appraisal of systems you know nothing about is an interesting concept,
being how you would do that rather than what suites the particular situation.

I will stick with Never make a table that the records cannot be deleted,
control this via logic rather than brawn.

I believe we have digressed enough.
 
Top