I don't want anything deleted

[Guest]

Hi

Is there a way to ensure that a user can NOT delete a Table, Query, FOrm etc
from the Database Window when they use the application?

I know some users have deleted all manner of files and folders from the
server but I want to ensure they do not bugger up my Access Application by
deleting any objects.

Of course I will always have a back up just in case but I'd rather just
secure it properly.

I have made it so the Database Window does not show when the program opens
but if anyone pushes F11 the window displays again so this is not entirely
safe.

Also, how can I stop them going into design mode.

Thanks in advance.

 

[Norman Yuan]

Give them the front-end application in *.mde format, instead of *.mdb.

 

[Douglas J. Steele]

While they cannot delete forms, reports or modules from MDE files, I think
they can still delete tables and queries (and macros, I believe) from an
MDE. (An MDE will prevent them from being able to go into design mode).

Of course, if the application is split into a front-end (containing the
queries, forms, reports, macros and modules) and a back-end (containing the
tables and relationships), it shouldn't really matter. Simply replace their
front-end each time they go to use the application.