Preventing certain rows from being deleted

[Deleted member 28156]

Hi
I would like to prevent the first 24 rows in a table from being deleted by the user, after these 24 rows they can be deleted. Is there anyway of protecting them etc without putting them in a separate table?

 

[IgorB]

You can but it depend on criterias.
For example if your rows have id(1 through 24) you might use query like this
"Delete * from MyTableName where id > 24".
By the way why don't you create a new field with autonumber data type which give you all numbers begins with 1 to the end of the table(i.e. last row) and use the above query?

Hope I helped you.
Igor.

 

[MStef]

Hello bikeboardsurf!

Look at "DemoPreventDeleteA2000.mdb"