softbless
asked on
Read Only REcord
Dear All,
Is there any way to make 1 record in a table to be read only, in other words : that 1 record cannot be deleted, or updated.
Please help. Thanks
Is there any way to make 1 record in a table to be read only, in other words : that 1 record cannot be deleted, or updated.
Please help. Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
MSSystems
I agree with the above mentioned. A trigger sounds like the easier solution. Alternatively you could add a second data file to the database with read only, but if I am not mistaken. That means you have to create an entire table for this record.
That is not a bad solution:
A read-only table for the single record and then a view to union the two tables.
A read-only table for the single record and then a view to union the two tables.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Let me see it
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Do you require any more help?
ASKER
THanks all