Yes, creating an MDE is a great way to prevent users from switching your
forms and reports into design view, and prevent them messing with the code.
To prevent them messing with the design, set the database's AllowByPassKey
and AllowSpecialKeys properties of the MDE file to False. Details at
support.microsoft.com in k.b. article 313915.
Other options include the full security, but that's generally overkill
unless you have particularly sensitive data.
Yes, each user should have their own copy of the front end. It can be in
their workspace on a server if necessary, but it will run faster and reduce
network traffic if the application is installed onto their local hard disk.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Simone" <oi****@hotmail.com> wrote in message
news:fc**************************@posting.google.c om...
I would like some advice.
What is the best way to make an Access database design not accessible?
Like accessing tables, form design and etc.
Is it a good idea to make a MDE file? What other options do I have?
On more question should all users have their own front end?
Thanks a lot.
Simone Dupre