MDE file still allows me to change database design

[qwertyjjj]

I've converted my DB into an MDE file as I understand this secures all the code and doesn't allow any changes to the database (table structure, queries, etc.).

However, when I now view my MDE file, I can still delete queries and change tables. But I cannot view forms in design mode and therefore get access to the code.

Any ideas?

 

[llkhoutx]

That's the way an MDE works.

You can hide the database window and disable the shift bypass startup to keep many users from making table and query changes; Access security will help incrementally more.

There's not absolute solution to your problem.

 

[GohDiamond]

I think you misunderstand what MDE does. Check the HELP under : About MDE files (MDB).

And yes, establishing user level security will let you control who can do what.

Goh

 

[boblarson]

Also, if you have the Access runtime license available, you can run an MDE using that and nobody can get in to anything in design mode.