Prevent table deletion

[knowledge76]

HI experts,

Is there a way to prevent the user to delete tables?
Or ask user when he tries to delete a table whether he is sure about deletion of that specific object.

Thanks in advance for your suggestions

 

[DCrake]

Why would you even let the user be in a position to even attempt to delete a table? Anyway tables should be linked tables and not reside in the local copy.

David

 

[knowledge76]

What is for the case when you as administrator deleted a table accidently.
In this case would such a routine with some dialogbox to show warning would not be helpful?

 

[DCrake]

As long as you don't close the mdb or run a compact and repair after deleting a table by mistake if you press Ctrl+Z it will restore the deleted table.

David

 

[knowledge76]

Thanks DClarke

 

[Lightwave]

You can also hide some tables although it is relativly easy to see them as you can go into the

Option menu and just click the show hidden objects button...

But it can mean that it is not possible for them to be highlighted even accidentally.